Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with Date, Group, Count, Cumulative Count(data below)
| Date | Group | Count | Cummulative Count |
| 01/01/1980 | A | 0 | 5115 |
| 09/01/1984 | B | 0 | 1364 |
| 01/01/1988 | A | 7 | 469 |
| 02/04/1988 | A | 0 | 2724 |
| 04/01/1988 | A | 1 | 392 |
| 06/01/1988 | A | 2 | 2903 |
| 05/01/1989 | A | 1 | 2972 |
| 07/15/1993 | A | 1 | 3046 |
| 08/01/1993 | A | 0 | 3580 |
| 11/01/1993 | A | 0 | 5328 |
| 11/30/1993 | B | 1 | 1423 |
| 12/08/1993 | A | 1 | 3774 |
| 12/13/1993 | A | 0 | 3728 |
| 12/15/1993 | A | 1 | 2926 |
| 12/31/1993 | A | 2 | 3682 |
| 01/01/1994 | A | 0 | 3368 |
| 01/10/1994 | A | 1 | 5107 |
| 02/02/1994 | A | 0 | 5315 |
| 02/08/1994 | A | 1 | 2935 |
| 02/08/1994 | B | 1 | 1293 |
| 03/29/1994 | B | 0 | 1307 |
| 04/10/1994 | B | 1 | 1955 |
For cummulative count I have tried the below code but I am getting some weird values
=aggr(Rangesum( above(
count (
[ID])
,0,RowNo())),Group,Date)
Referred: https://community.qlik.com/t5/New-to-Qlik-Sense/Rangesum-cumulative-with-2-dimensions/td-p/1285355
Though if I try without the grouping(aggr function) I get the right values.
Thanks,
It worked
Thanks alot!!!