topic Re: Rolling Count in App Development

topic Re: Rolling Count in App Development https://community.qlik.com/t5/App-Development/Rolling-Count/m-p/2060230#M87002 <P>RangeSum(Above(Sum(<STRONG>Count</STRONG>), 0, RowNo()))</P> Thu, 13 Apr 2023 18:45:18 GMT BrunPierre 2023-04-13T18:45:18Z Rolling Count https://community.qlik.com/t5/App-Development/Rolling-Count/m-p/2060163#M86999 <TABLE width="654"> <TBODY> <TR> <TD width="87"> </TD> <TD width="87"> </TD> <TD width="133"> </TD> <TD width="347"> </TD> </TR> <TR> <TD> </TD> <TD>Week</TD> <TD>Count(Distinct id)</TD> <TD>Expected output</TD> </TR> <TR> <TD> </TD> <TD>WK1</TD> <TD>10</TD> <TD>10</TD> </TR> <TR> <TD> </TD> <TD>WK2</TD> <TD>15</TD> <TD>25</TD> </TR> <TR> <TD> </TD> <TD>WK3</TD> <TD>10</TD> <TD>35</TD> </TR> <TR> <TD> </TD> <TD>WK4</TD> <TD>50</TD> <TD>85</TD> </TR> <TR> <TD> </TD> <TD>WK5</TD> <TD>30</TD> <TD>115</TD> </TR> <TR> <TD> </TD> <TD>WK6</TD> <TD>20</TD> <TD>135</TD> </TR> <TR> <TD> </TD> <TD>WK7</TD> <TD>10</TD> <TD>145</TD> </TR> <TR> <TD> </TD> <TD>WK8</TD> <TD>60</TD> <TD>205</TD> </TR> <TR> <TD> </TD> <TD>WK9</TD> <TD>20</TD> <TD>225</TD> </TR> <TR> <TD> </TD> <TD>WK10</TD> <TD>15</TD> <TD>240</TD> </TR> </TBODY> </TABLE> Thu, 13 Apr 2023 15:21:42 GMT https://community.qlik.com/t5/App-Development/Rolling-Count/m-p/2060163#M86999 tsachdev421 2023-04-13T15:21:42Z Re: Rolling Count https://community.qlik.com/t5/App-Development/Rolling-Count/m-p/2060230#M87002 <P>RangeSum(Above(Sum(<STRONG>Count</STRONG>), 0, RowNo()))</P> Thu, 13 Apr 2023 18:45:18 GMT https://community.qlik.com/t5/App-Development/Rolling-Count/m-p/2060230#M87002 BrunPierre 2023-04-13T18:45:18Z Re: Rolling Count https://community.qlik.com/t5/App-Development/Rolling-Count/m-p/2060238#M87004 <P>What if I want to use final count in KPI</P> Thu, 13 Apr 2023 18:54:24 GMT https://community.qlik.com/t5/App-Development/Rolling-Count/m-p/2060238#M87004 tsachdev421 2023-04-13T18:54:24Z