Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I try to do a cumulative sum in QlickView, in a pivot table, but it doesn't work.
Any help, please?
For example: 712.490 it must be in line in 201911 and 201912.
I have "-". In total, it is calculated right, but in rows, no.
In script I have: ISNULL(RealizedValue,0), but in the table appears "-".
For "Insurance" it is okay:
in 201911 -> 178,768.080 + 178,768.080 = 357,536.160 ,
then in 201912 -> 357,536.160 + 178,768.090 = 536,304.240
Also, for "Broker Fees" it is okay. But for "Management fee+payroll" and "Salaries" I don't know what to do..
I write this expression:
RangeSum(before(sum(DISTINCT REALIZEDVALUE),0,ColumnNo()))
+
alt(
sum(DISTINCT
Aggr(NODISTINCT
sum (
{1
<PERIOD={"< $(=Max(PeriodNumeric))"}>
}
TOTAL <CATEGORY1,CATEGORY2>
DISTINCT REALIZEDVALUE)
,CATEGORY1,CATEGORY2)
)
,0)
Thank you!
You might need to Generate Missing Data in order to accomplish this
Iulian, did Sunny's link get you what you needed? If so, and it provided what you needed, do not forget to use the Accept as Solution Button on Sunny's post to mark it. If you did something else, consider posting that and mark it, and if you are still working upon things, leave an update as to where you stand.
Found the following Design Blog post as well that may be helpful:
https://community.qlik.com/t5/Qlik-Design-Blog/Accumulative-Sums/ba-p/1468010
Regards,
Brett