topic Cumulative Sum QlickView in QlikView

Cumulative Sum QlickView

qbsretail — Sat, 16 Nov 2024 19:57:05 GMT

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!

Re: Cumulative Sum QlickView

sunny_talwar — Mon, 07 Oct 2019 12:55:16 GMT

You might need to Generate Missing Data in order to accomplish this

Re: Cumulative Sum QlickView

Brett_Bleess — Mon, 14 Oct 2019 13:59:43 GMT

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