Block hidden if

Hervé BEURET
Hervé BEURET Customer
Third Anniversary First Comment
edited June 2022 in Platform
Hello,

I have a layout with 3 blocks. All have data entry available. I would like to display the third block only if the user has selected a specific entity.
Let's say my entity is the year, I would like to display the block "c" only if the user has selected the year 2022.
If the year is not 2022 i would like to see only the blocks "a" and "b".
That should be automatic and not through a manual action from the user.

Thanks

Hervé


------------------------------
Hervé BEURET
Senior Controller, Budget & Control
FONDATION INSEAD
France
------------------------------
Tagged:

Accepted Answer

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    edited June 2022 Answer ✓
    Hi @Hervé BEURET,

    first of all, you'd need to untick the "show all" option for the columns.
    Secondly, your third block will need to be an algorithm that represents the cube's data on the condition that the selection is set according to your needs (i.e. if(<select>, x,0) where "x" represents your cube's data). Since this new block is an algorithm you'd have to use an inverse algorithm in order to write the data entered by the user to the data-entry cube (you might consider using Nexel writeback, here).

    Kind regards
    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------

Answers

  • Hervé BEURET
    Hervé BEURET Customer
    Third Anniversary First Comment
    edited June 2022
    Thanks @Helmut Heimann
    I would probably need more help on that inverse algorithm.

    Currently I have my algorithm in block "f" and my original cube in block "e" :

    image

    thanks

    Herve


    ------------------------------
    Hervé BEURET
    Senior Controller, Budget & Control
    FONDATION INSEAD
    France
    ------------------------------
    -------------------------------------------
  • Hervé BEURET
    Hervé BEURET Customer
    Third Anniversary First Comment
    edited June 2022
    That works now.

    Thanks

    ------------------------------
    Hervé BEURET
    Senior Controller, Budget & Control
    FONDATION INSEAD
    France
    ------------------------------
    -------------------------------------------
  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    edited June 2022
    Nice, great to hear that

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------

Categories