Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to everyone, I created in Qlik Front-end a straight table like the one attached.
My aim is to obtain the result in column E and so the cumulative sum of column C.
But for now I only managed to obtain the result in column D thanks to this expression:
sum(AGGR(RangeSum(above( COUNT({SetAnalysis} %KEY_INT),0,RowNo())),N))
I have problems to deal with null values...
Thanks in advance
Eva
Hi Eva,
Maybe this could work for you, I'm not showing the full straight table:
dd | [No claims] | Rangesum | Desired |
---|---|---|---|
Fino a 8,00 | 6744 | 6744 | 6744 |
Fino a 38,42 | 8099 | 14843 | 14843 |
Fino a 68,83 | 1567 | 16410 | 16410 |
Fino a 99,25 | 383 | 16793 | 16793 |
Fino a 129,67 | 286 | 17079 | 17079 |
Fino a 160,08 | 250 | 17329 | 17329 |
Fino a 190,50 | 144 | 17473 | 17473 |
Fino a 220,92 | 56 | 17529 | 17529 |
Fino a 251,33 | 30 | 17559 | 17559 |
Fino a 281,75 | 11 | 17570 | 17570 |
Fino a 312,17 | 27 | 17597 | 17597 |
Fino a 342,58 | 23 | 17620 | 17620 |
Fino a 373,00 | 3 | 17623 | 17623 |
Fino a 403,42 | 1 | 17624 | 17624 |
Fino a 433,83 | 0 | 17624 | 17624 |
Fino a 464,25 | 0 | 17624 | 17624 |
Fino a 494,67 | 1 | 17625 | 17625 |
Fino a 525,08 | 2 | 17627 | 17627 |
Fino a 555,50 | 1 | 17628 | 17628 |
Fino a 585,92 | 0 | 17628 | 17628 |
Fino a 616,33 | 2 | 17630 | 17630 |
Fino a 646,75 | 0 | 17630 | 17630 |
Fino a 677,17 | 2 | 17632 | 17632 |
Fino a 707,58 | 0 | 17632 | 17632 |
Fino a 738,00 | 0 | 17632 | 17632 |
Fino a 768,42 | 1 | 17633 | 17633 |
Fino a 798,83 | 0 | 17633 | 17633 |
Fino a 829,25 | 0 | 17633 | 17633 |
Fino a 859,67 | 0 | 17633 | 17633 |
Fino a 890,08 | 0 | 17633 | 17633 |
There is a single dimension : dd
[No claims] is entered as an expression and the expression titled Rangesum is:
Rangesum(above([No claims],0,RowNo()))
Good luck
Andrew
Hi Andrew, look at the last column in below image ...it doesn't work
Hi Eva,
How many dimensions do you have in your table? The expression will not work if there is more than one. Replace the dimensions except one with expressions.
all the best
Andrew