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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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