Dynamic Header on Dataview

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.

Find more posts tagged with

Capsules

Layout

Dataview

Accepted answers

All comments

Akrem ABDELHAFIDH

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:

Block 1: header “XXX” (set the block as hidden)
Block 2: header “YYY” (set the block as hidden)
Block 3: use a condition such as IF(A > 30, Block 1, Block 2) to display the appropriate block

This way you dynamically control what the user sees, even though the header itself cannot be conditional.

Putra

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.

Akrem ABDELHAFIDH

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:

Block 1 → IF(a > 30, Block1, 0) with header “XXX”
Block 2 → IF(a < 30, Block2, 0) with header “YYY”

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.

Putra

Hi Akrem,

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.