topic Rank Periods in QlikView https://community.qlik.com/t5/QlikView/Rank-Periods/m-p/875880#M470254 <HTML><HEAD></HEAD><BODY><P>Morning all,</P><P></P><P>I would like to calculate a rolling average over 6 periods. I have implemented a rangesum calculation that works well, but the problem is that if it is the first period, I would like to write an if statement that there is only one period and thus QV must only divide by 1 if it is the second period, it must divide by 2 and from 3 periods onwards it can divide by 3...</P><P></P><P>The formula that I have implemented looks as follows:</P><P>(sum(m1_total_revenue) + rangesum(above(sum(m1_total_revenue),1,1)) + rangesum(above(sum(m1_total_revenue),2,1)))/3</P><P></P><P>and this is in a pivot table that has been set out per period..</P><P></P><P>thank you for your assistance,</P><P>L</P></BODY></HTML> Fri, 29 May 2015 06:51:30 GMT 2015-05-29T06:51:30Z Rank Periods https://community.qlik.com/t5/QlikView/Rank-Periods/m-p/875880#M470254 <HTML><HEAD></HEAD><BODY><P>Morning all,</P><P></P><P>I would like to calculate a rolling average over 6 periods. I have implemented a rangesum calculation that works well, but the problem is that if it is the first period, I would like to write an if statement that there is only one period and thus QV must only divide by 1 if it is the second period, it must divide by 2 and from 3 periods onwards it can divide by 3...</P><P></P><P>The formula that I have implemented looks as follows:</P><P>(sum(m1_total_revenue) + rangesum(above(sum(m1_total_revenue),1,1)) + rangesum(above(sum(m1_total_revenue),2,1)))/3</P><P></P><P>and this is in a pivot table that has been set out per period..</P><P></P><P>thank you for your assistance,</P><P>L</P></BODY></HTML> Fri, 29 May 2015 06:51:30 GMT https://community.qlik.com/t5/QlikView/Rank-Periods/m-p/875880#M470254 2015-05-29T06:51:30Z