Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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 (2)
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 .