If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi All ,
Please kindly assist me to get the cumulative number for the below table .
How to get the cumulative value - R1,621,456
R1,621,456 + R9,372,516
R1,621,456 + R9,372,516 + 6,899,589 and so on
Cumulative value like the arrow shows from below to top -
Try this
Sum(
Aggr(RangeSum(Above(Sum(Measure), 0, RowNo())), [UW Month], ([Claims Payment Month], (NUMERIC)))
)
May be this
Aggr(RangeSum(Above(Sum(Measure), 0, RowNo())), [UW Month], ([Claims Payment Month], (NUMERIC)))
Hi Sunny ,
It works, but the total is not working . Please see the image below -
Total should be = R10,993,972 + R 2,391,220 ?
Try this
Sum(
Aggr(RangeSum(Above(Sum(Measure), 0, RowNo())), [UW Month], ([Claims Payment Month], (NUMERIC)))
)
Thank you .