Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.