topic problem with chart inter record function in QlikView https://community.qlik.com/t5/QlikView/problem-with-chart-inter-record-function/m-p/433906#M569231 <HTML><HEAD></HEAD><BODY><P>I have a strange problem.I need to calculate running total for a chart, I was able to do it by below() and noofrows() function.the dimensions are customer and monthyear,but extra rows with zero values are added for every monthyear.Suppresing zero values and null values was not useful.Any ideas please how to get rid of the zero values?</P></BODY></HTML> Fri, 19 Oct 2012 15:02:13 GMT 2012-10-19T15:02:13Z problem with chart inter record function https://community.qlik.com/t5/QlikView/problem-with-chart-inter-record-function/m-p/433906#M569231 <HTML><HEAD></HEAD><BODY><P>I have a strange problem.I need to calculate running total for a chart, I was able to do it by below() and noofrows() function.the dimensions are customer and monthyear,but extra rows with zero values are added for every monthyear.Suppresing zero values and null values was not useful.Any ideas please how to get rid of the zero values?</P></BODY></HTML> Fri, 19 Oct 2012 15:02:13 GMT https://community.qlik.com/t5/QlikView/problem-with-chart-inter-record-function/m-p/433906#M569231 2012-10-19T15:02:13Z Re: problem with chart inter record function https://community.qlik.com/t5/QlikView/problem-with-chart-inter-record-function/m-p/433907#M569232 <HTML><HEAD></HEAD><BODY><P>hi kevincool,</P><P></P><P>Try to solve it on script level and stop loading of extra rows with zero value.</P><P></P><P>Regards</P><P></P><P>-Anil</P></BODY></HTML> Fri, 19 Oct 2012 16:08:58 GMT https://community.qlik.com/t5/QlikView/problem-with-chart-inter-record-function/m-p/433907#M569232 2012-10-19T16:08:58Z Re: problem with chart inter record function https://community.qlik.com/t5/QlikView/problem-with-chart-inter-record-function/m-p/433908#M569233 <HTML><HEAD></HEAD><BODY><P>Is it possible for you to post your expression?</P><P>May be use of Aggr function you can solve this.. </P></BODY></HTML> Fri, 19 Oct 2012 16:51:08 GMT https://community.qlik.com/t5/QlikView/problem-with-chart-inter-record-function/m-p/433908#M569233 CELAMBARASAN 2012-10-19T16:51:08Z Re: problem with chart inter record function https://community.qlik.com/t5/QlikView/problem-with-chart-inter-record-function/m-p/433909#M569234 <HTML><HEAD></HEAD><BODY><P>Thanks all, I sorted it out now.The working expression is:</P><P></P><P>NUM(RANGESUM(RANGESUM(Debit, Credit), Below(TOTAL RANGESUM(Debit, Credit), 1, NoOfRows()-1)), e_currency_format_decimal)</P><P></P><P></P><P>where debit and credit are two different expressions and I have to show a running total of the both in descending order of monthyear.</P></BODY></HTML> Fri, 19 Oct 2012 19:07:18 GMT https://community.qlik.com/t5/QlikView/problem-with-chart-inter-record-function/m-p/433909#M569234 2012-10-19T19:07:18Z