Block hidden if

Hervé BEURET

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
------------------------------

Helmut Heimann

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
------------------------------
-------------------------------------------