Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 
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 (2)
2 Replies
Creator II
Creator II

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


Contributor III
Contributor III

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