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: 
elodie-sta
Contributor
Contributor

In a pivot table : how to hide 2rd level columns for some 1st level columns ?

(Sorry in advance, English isn't my primary language)

Hello everyone, 

I'm facing a particular issue : I have a pivot table in which the first elements of the Columns part are "Values" from the measures I've added (it was generated automatically) and the second element is a normal dimension "Motif de sortie".

elodiesta_0-1742207069865.png

 

I need to make sure that the columns of my "Motif de sortie" elements hide for some columns of my 1st dimensions (Values). 

For example, I have 3 columns of Values : a, b and c and for "Motif de sortie" I have the columns 1, 2, 3

I want b and c to have the columns 1, 2, 3 but not a.

 

Do you have a solution for this ? I thought about using "Show column if" but I don't know how to select the "Values" element in the expression

Labels (4)
2 Replies
Chanty4u
MVP
MVP

You can use this in show column if 

=IF(Match(Only([Values]), 'b', 'c'), 1, 0)

 

elodie-sta
Contributor
Contributor
Author

In the expression do you replace the "Values" element by something else ?

Because as such, it doesn't work for me