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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
pgonin
Contributor II
Contributor II

Hide column filled only with nulls

Hello dears!

Please tell me how to hide a column in pivot table which has only zeros (nulls) - see example below. I know about unchecking button "include zero values" and "include null values". Normally, if I have only one measure, it works correctly, but I have to add one more measure (which has a lot of null values for prior months). 

In this particular case I want to hide month "2018-01" in measure "LM growth"

 

Capture.PNG

 
Labels (1)
1 Reply
Anna_Klimkova
Employee
Employee

You can't hide this month because you have values (not null) for month "2018-01" in the first measure Sum .