topic Hide zero lines in cummulative pivot table in QlikView https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196914#M385973 <HTML><HEAD></HEAD><BODY><P>Hi all!,</P><P></P><P>Can anyone help me out on this challenge?</P><P></P><P>in attached QlikView document there is a pivot finincial cumulative balance. The numbers are presented correctly but I want to hide the lines where every month (and thus total) is a zero.</P><P></P><P>I've tried the regular checkboxes, expressions but I can't get it to work.</P><P></P><P>Any help appreciated!</P><P></P><P>Regards,</P><P></P><P>Bart</P></BODY></HTML> Thu, 27 Oct 2016 09:24:49 GMT bartvanwetten 2016-10-27T09:24:49Z Hide zero lines in cummulative pivot table https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196914#M385973 <HTML><HEAD></HEAD><BODY><P>Hi all!,</P><P></P><P>Can anyone help me out on this challenge?</P><P></P><P>in attached QlikView document there is a pivot finincial cumulative balance. The numbers are presented correctly but I want to hide the lines where every month (and thus total) is a zero.</P><P></P><P>I've tried the regular checkboxes, expressions but I can't get it to work.</P><P></P><P>Any help appreciated!</P><P></P><P>Regards,</P><P></P><P>Bart</P></BODY></HTML> Thu, 27 Oct 2016 09:24:49 GMT https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196914#M385973 bartvanwetten 2016-10-27T09:24:49Z Re: Hide zero lines in cummulative pivot table https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196915#M385974 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/142193_Capture.PNG" style="height: 283px; width: 620px;" /></P></BODY></HTML> Thu, 27 Oct 2016 09:28:58 GMT https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196915#M385974 sunny_talwar 2016-10-27T09:28:58Z Re: Hide zero lines in cummulative pivot table https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196916#M385975 <HTML><HEAD></HEAD><BODY><P>Sunny,</P><P></P><P>do you ever sleep? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>No it's not the way because my numbers change. It should just 'remove' the lines in wich every month is a zero (or null?) amount.</P><P></P><P>Thx mate!</P></BODY></HTML> Thu, 27 Oct 2016 10:02:31 GMT https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196916#M385975 bartvanwetten 2016-10-27T10:02:31Z Re: Hide zero lines in cummulative pivot table https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196917#M385976 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>the solution you offered was right! The result differs between qv11 and qv12. Check it out.</P><P>So back to 11 I guess :s</P><P></P><P>Bart</P></BODY></HTML> Thu, 27 Oct 2016 14:22:06 GMT https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196917#M385976 bartvanwetten 2016-10-27T14:22:06Z Re: Hide zero lines in cummulative pivot table https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196918#M385977 <HTML><HEAD></HEAD><BODY><P>So there is an issue between QV11 and QV12? Which one is giving the right numbers?</P></BODY></HTML> Thu, 27 Oct 2016 14:23:27 GMT https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196918#M385977 sunny_talwar 2016-10-27T14:23:27Z Re: Hide zero lines in cummulative pivot table https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196919#M385978 <HTML><HEAD></HEAD><BODY><P>11!</P></BODY></HTML> Thu, 27 Oct 2016 14:24:30 GMT https://community.qlik.com/t5/QlikView/Hide-zero-lines-in-cummulative-pivot-table/m-p/1196919#M385978 bartvanwetten 2016-10-27T14:24:30Z