topic Re: Suppress null values in pivot table in QlikView https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647013#M1072200 <HTML><HEAD></HEAD><BODY><P>Use the IF condition in the experssion to avoid the null values.....but the above methods are the way to avoid the null values in the pivot table...</P></BODY></HTML> Mon, 11 Aug 2014 14:18:09 GMT 2014-08-11T14:18:09Z Suppress null values in pivot table https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647006#M1072193 <HTML><HEAD></HEAD><BODY><P>HOw can we supress zero values in Pivot table? is there any limitation? I am not able to avoid zero values in the table</P></BODY></HTML> Fri, 08 Aug 2014 10:13:53 GMT https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647006#M1072193 rsdhavle 2014-08-08T10:13:53Z Re: Suppress null values in pivot table https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647007#M1072194 <HTML><HEAD></HEAD><BODY><P>give the condition which u gave in the expression in the dimension tab as calculated dimension and check the box suppress when null values.....</P></BODY></HTML> Fri, 08 Aug 2014 10:24:42 GMT https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647007#M1072194 2014-08-08T10:24:42Z Re: Suppress null values in pivot table https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647008#M1072195 <HTML><HEAD></HEAD><BODY><P>In presentation tab check suppress zero values</P></BODY></HTML> Fri, 08 Aug 2014 10:27:51 GMT https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647008#M1072195 2014-08-08T10:27:51Z Re: Suppress null values in pivot table https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647009#M1072196 <HTML><HEAD></HEAD><BODY><P>Can you attach a sample app.</P></BODY></HTML> Fri, 08 Aug 2014 10:32:08 GMT https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647009#M1072196 2014-08-08T10:32:08Z Re: Suppress null values in pivot table https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647010#M1072197 <HTML><HEAD></HEAD><BODY><P>Suppress the zero values of dimension by goto dimension tab and check the option Suppress when value is null or go to presentation tab and check the option suppress zero values.. Hope this will help you</P><P></P><P>Regards</P><P>Bhawna</P></BODY></HTML> Fri, 08 Aug 2014 10:34:06 GMT https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647010#M1072197 2014-08-08T10:34:06Z Re: Suppress null values in pivot table https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647011#M1072198 <HTML><HEAD></HEAD><BODY><P>its not working</P></BODY></HTML> Mon, 11 Aug 2014 06:21:58 GMT https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647011#M1072198 rsdhavle 2014-08-11T06:21:58Z Re: Suppress null values in pivot table https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647012#M1072199 <HTML><HEAD></HEAD><BODY><P>Hi Rohan,</P><P></P><P></P><P>Chart properties-&gt; Presentation-&gt;</P><P></P><P><IMG alt="qvissue1.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/64121_qvissue1.PNG.png" style="width: 620px; height: 543px;" /></P><P></P><P>hope this helps</P></BODY></HTML> Mon, 11 Aug 2014 07:10:01 GMT https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647012#M1072199 2014-08-11T07:10:01Z Re: Suppress null values in pivot table https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647013#M1072200 <HTML><HEAD></HEAD><BODY><P>Use the IF condition in the experssion to avoid the null values.....but the above methods are the way to avoid the null values in the pivot table...</P></BODY></HTML> Mon, 11 Aug 2014 14:18:09 GMT https://community.qlik.com/t5/QlikView/Suppress-null-values-in-pivot-table/m-p/647013#M1072200 2014-08-11T14:18:09Z