My client using Board 14.2. Is there any possibility to do some Dynamic Header on Data view. Such as, if cube a<30,"XXX","YYY". I tried to put the formula on Header, but the visibility of the Header on Play Mode still the formula itself.
Hello @Putra
In Board it’s not possible to apply conditional logic (IF statements) directly on Data View headers.
To achieve a similar result, you can use a workaround with 3 blocks:
IF(A > 30, Block 1, Block 2)
This way you dynamically control what the user sees, even though the header itself cannot be conditional.
Hi Akrem,
Thanks for the insight, really appreciate it. Actually, we did the way you told. The value is on point, but we have to find the name of the header.
Hi @Putra , glad it helped 🙂 I actually have a small trick to manage the header dynamically.
You can disable Show all columns,
then use two IF blocks:
IF(a > 30, Block1, 0)
IF(a < 30, Block2, 0)
Since columns returning 0 won’t be displayed, only the block with the correct condition will appear — along with its corresponding header.
Let me know if you want me to share a quick example setup.
Ahhh. I tried that one. The if condition with zero value. But, the difference is I dont set the "By Column". So, the all column on datablock still be shown but when the condition zero is triggered, the column on that datablock will show zero value without hiding. Okay, let's try it. Thanks a lot.
Dear @Putra,
B14.4 introduced some new functionalities related to @Entity and @Selection _Ex Substitution Formulas in Block Headers to make it dynamic. Not exactly what you were looking forward but could be useful.
https://help.board.com/v14/docs/platform-enhancements#entity-and-selectionex-substitution-formulas-in-block-headers
Hi @Putra ,
In Board 14.2, dynamic headers in a Data View (like using a formula such as IF(Cube A < 30, "XXX", "YYY")) are not directly supported. That’s why in Play mode the header still displays the formula instead of the evaluated result.
IF(Cube A < 30, "XXX", "YYY")
However, there is an alternate approach you can use:
You can configure an Expander and create two separate Data Views, each with a fixed header (e.g., one with header “XXX” and the other with “YYY”).
Then, manage the visibility of these two Data Views based on the condition Cube A < 30:
Cube A < 30
This way, although the header itself is not dynamically calculated, the displayed Data View (and therefore the header) will change dynamically based on the cube condition.
Thanks!
