Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
GabrielOtet
Contributor III
Contributor III

Hide/Unhide a Column based on 'Show Column if'

Dear all,

I'm quite new into Qlik Sense and I have a problem that I cannot solve and also could not find a proper answer until now.

I have a Pivot table. In the Row part, I have two fields which filter trough another two fields (please see the image below). I'll like to hide Row 3&4 for List 2 but keep them on for List 1.

Until now, I could not find a solution and the table is looking a bit ugly.

Can someone help me here?

Pivot hide rowsPivot hide rows

 

Labels (1)
2 Replies
skamath1
Creator III
Creator III

Try the turn off the setting Include null values in the Dimension Property for all the dimension.


Capture1.PNG

GabrielOtet
Contributor III
Contributor III
Author

Unfortunately it is not possible for one of the dimensions I have.

The Values Dimension (see below) is not editable and cannot touch it. Dimensions.PNG