Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.