topic Re: Hide missing values from Pivot Report in QlikView https://community.qlik.com/t5/QlikView/Hide-missing-values-from-Pivot-Report/m-p/518611#M555907 <HTML><HEAD></HEAD><BODY><P>This does not work because, if one of your fields has 0 or '-' or NULL the other field has value for that record. if you want to hide the row for a certain field's content (0 or null or '-') then you have to put a conditional expression(presentation tab) for all the columns with same expression.</P><P></P><P>Hope this helps.</P></BODY></HTML> Wed, 24 Jul 2013 09:50:32 GMT tresB 2013-07-24T09:50:32Z Hide missing values from Pivot Report https://community.qlik.com/t5/QlikView/Hide-missing-values-from-Pivot-Report/m-p/518610#M555906 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>I have pivot report I want to hide all values having zero's or null or -&nbsp; in&nbsp; , I tick option <STRONG>supress when values is null&nbsp; </STRONG></P><P>option but still I am not able to hide this values. </P><P></P><P>please help me to achive the same .</P><P></P><P>Thanks</P><P></P><P>Vikas</P></BODY></HTML> Wed, 24 Jul 2013 09:35:29 GMT https://community.qlik.com/t5/QlikView/Hide-missing-values-from-Pivot-Report/m-p/518610#M555906 vikasmahajan 2013-07-24T09:35:29Z Re: Hide missing values from Pivot Report https://community.qlik.com/t5/QlikView/Hide-missing-values-from-Pivot-Report/m-p/518611#M555907 <HTML><HEAD></HEAD><BODY><P>This does not work because, if one of your fields has 0 or '-' or NULL the other field has value for that record. if you want to hide the row for a certain field's content (0 or null or '-') then you have to put a conditional expression(presentation tab) for all the columns with same expression.</P><P></P><P>Hope this helps.</P></BODY></HTML> Wed, 24 Jul 2013 09:50:32 GMT https://community.qlik.com/t5/QlikView/Hide-missing-values-from-Pivot-Report/m-p/518611#M555907 tresB 2013-07-24T09:50:32Z