Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Louveduval
Creator
Creator

show columns in a table when a state of hierachy appear

Hello 

I would like to show columns in a table when a state of hierachy appear, here " Code article" 

Louveduval_0-1700662325421.png


So I want to appear this column : 

Louveduval_1-1700662386972.png

when  we are at the "Code article" level 

 

does it possible or not ?  Can you help me ? 

Best regard 

Labels (3)
1 Solution

Accepted Solutions
Aasir
Creator III
Creator III

Create a Calculated Dimension:

=If(Match(HierarchyField, 'Code article'), YourDimension, '-')
Replace YourDimension with the dimension you want to display when the hierarchy is at the "Code article" level.

You can do a similar thing with Calculated measure too

View solution in original post

4 Replies
Or
MVP
MVP

As far as I know this is not something you can reference in itself, but you can make a column visible only when Count(distinct [Niveau 5])=1, which should provide the same result under most circumstances.

Louveduval
Creator
Creator
Author

Louveduval_0-1700665981216.png

Sadly, it doesn't work Count(distinct [Niveau 5])=1 
and if I write >=1  then 

Louveduval_1-1700666313955.pngThe column appear for the other hierachy 

 

Aasir
Creator III
Creator III

Create a Calculated Dimension:

=If(Match(HierarchyField, 'Code article'), YourDimension, '-')
Replace YourDimension with the dimension you want to display when the hierarchy is at the "Code article" level.

You can do a similar thing with Calculated measure too

Louveduval
Creator
Creator
Author

Sorry, How can you add an Hierarchy dimension in a Calculated Dimension ?