Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hide/show columns on the basis of group column

I have one table, a,b,c columns in which A is a group, A group has 3 levels data.

A1, A2, A3

now by default table shows level 3, A3

A3 , b, c

and i want to show another column flag when i drill down to level 1 as A1

output should be A1,flag, b,c (when i drill down to A1)

conditional column i am using  but prob is when i click on A3 column it directly goes to A1, its not showing me A2

Any idea why its not showing the A2?

I have checked all the data, i have data for A2

1 Reply
Not applicable
Author

Hi Mugdha,

What's the conditional sum you're using? I would try something like this in the expressions:

=if(Match(GetCurrentField([GroupName]), 'FieldName'),1,0)

So for instance, to show your flag field when A1 is shown, adding this condition to the flag should work:

=if(Match(GetCurrentField(), 'A1'),1,0)

Would be better if you attach a sample, but hopefully this helps you out.

Matt