Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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 ?