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: 
Myname123
Partner - Contributor
Partner - Contributor

Pivot Table

Hi all, So the thing is I have to display the branches with 0 values. But for me the Branches with non zero values are getting displayed as a grey space. I want to remove the rows with non zero values(grey space). 

if(count(DumpAREA)=0,'0') this is my set expression.

2 Replies
agni_gold
Specialist III
Specialist III

are you looking this in Qliksense?
Myname123
Partner - Contributor
Partner - Contributor
Author

Yes I'm using qliksense only.