topic Re: how to hide row in pivot table, in QlikView https://community.qlik.com/t5/QlikView/how-to-hide-row-in-pivot-table/m-p/257954#M97429 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>first write the if condition based on which field you want to hide on Add Calculated Dimension section in the Dimension section of in the pivot table.Then select or check the check box of suppress null value.I've Attached one application based on your requirement. hope it helps.</P><P></P><P>Warm Regards,</P><P>Arun Prasadh.N.</P></BODY></HTML> Tue, 07 Feb 2012 06:38:42 GMT 2012-02-07T06:38:42Z how to hide row in pivot table, https://community.qlik.com/t5/QlikView/how-to-hide-row-in-pivot-table/m-p/257952#M97427 <HTML><HEAD></HEAD><BODY><P> <SPAN class="hps">how to hide</SPAN> <SPAN class="hps">row in</SPAN> <SPAN class="hps">pivot table, </SPAN></P><P><SPAN class="hps"> </SPAN></P><P><SPAN class="hps">help me thanks</SPAN></P></BODY></HTML> Mon, 06 Feb 2012 22:57:39 GMT https://community.qlik.com/t5/QlikView/how-to-hide-row-in-pivot-table/m-p/257952#M97427 2012-02-06T22:57:39Z how to hide row in pivot table, https://community.qlik.com/t5/QlikView/how-to-hide-row-in-pivot-table/m-p/257953#M97428 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Using If statement set those rows expression values to 0 for the rows which you want to hide.</P><P></P><P>In a row if all the expression values are 0 then that row is removed by default.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 07 Feb 2012 05:47:05 GMT https://community.qlik.com/t5/QlikView/how-to-hide-row-in-pivot-table/m-p/257953#M97428 jagan 2012-02-07T05:47:05Z Re: how to hide row in pivot table, https://community.qlik.com/t5/QlikView/how-to-hide-row-in-pivot-table/m-p/257954#M97429 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>first write the if condition based on which field you want to hide on Add Calculated Dimension section in the Dimension section of in the pivot table.Then select or check the check box of suppress null value.I've Attached one application based on your requirement. hope it helps.</P><P></P><P>Warm Regards,</P><P>Arun Prasadh.N.</P></BODY></HTML> Tue, 07 Feb 2012 06:38:42 GMT https://community.qlik.com/t5/QlikView/how-to-hide-row-in-pivot-table/m-p/257954#M97429 2012-02-07T06:38:42Z