topic Re: How to remove the zero row in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-the-zero-row/m-p/669812#M243393 <HTML><HEAD></HEAD><BODY><P>Several ways are there, one is like:</P><P>Re-write first exp as: If(sum(Amout)=0,0,max(SpotRate))</P><P></P><P>Then enable zero supression on presentation tab. Important to note that zero supression works when all exp columns are zero (that is what made forcefully)</P></BODY></HTML> Wed, 13 Aug 2014 05:55:46 GMT tresB 2014-08-13T05:55:46Z How to remove the zero row https://community.qlik.com/t5/QlikView/How-to-remove-the-zero-row/m-p/669811#M243392 <HTML><HEAD></HEAD><BODY><P>HI All,</P><P></P><P>I have one doc, which is attached.</P><P></P><P>This doc only includes a pivot table to show the revenue by Region.</P><P></P><P>One thing is, I want to hide the row whosw Amout is 0, how to do it?</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 13 Aug 2014 05:50:42 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-zero-row/m-p/669811#M243392 2014-08-13T05:50:42Z Re: How to remove the zero row https://community.qlik.com/t5/QlikView/How-to-remove-the-zero-row/m-p/669812#M243393 <HTML><HEAD></HEAD><BODY><P>Several ways are there, one is like:</P><P>Re-write first exp as: If(sum(Amout)=0,0,max(SpotRate))</P><P></P><P>Then enable zero supression on presentation tab. Important to note that zero supression works when all exp columns are zero (that is what made forcefully)</P></BODY></HTML> Wed, 13 Aug 2014 05:55:46 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-zero-row/m-p/669812#M243393 tresB 2014-08-13T05:55:46Z Re: How to remove the zero row https://community.qlik.com/t5/QlikView/How-to-remove-the-zero-row/m-p/669813#M243394 <HTML><HEAD></HEAD><BODY><P>Hi Isaac,</P><P></P><P>Please find the attachment for the solution.</P><P></P><P>Regards,</P><P>@vi</P></BODY></HTML> Wed, 13 Aug 2014 06:02:44 GMT https://community.qlik.com/t5/QlikView/How-to-remove-the-zero-row/m-p/669813#M243394 avinashelite 2014-08-13T06:02:44Z