https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1606722#M44966 are you looking this in Qliksense? Sat, 27 Jul 2019 21:31:42 GMT agni_gold 2019-07-27T21:31:42Z https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1606430#M44912 <P>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).&nbsp;</P><P>if(count(DumpAREA)=0,'0') this is my set expression.</P> Fri, 26 Jul 2019 09:39:19 GMT https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1606430#M44912 Myname123 2019-07-26T09:39:19Z https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1606722#M44966 are you looking this in Qliksense? Sat, 27 Jul 2019 21:31:42 GMT https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1606722#M44966 agni_gold 2019-07-27T21:31:42Z https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1606807#M44979 <P>Yes I'm using qliksense only.</P> Mon, 29 Jul 2019 05:03:38 GMT https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1606807#M44979 Myname123 2019-07-29T05:03:38Z