Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qbsretail
Contributor III
Contributor III

Cumulative Sum QlickView

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)

clipboard_image_1.png

 

Thank you!

Labels (1)
2 Replies
sunny_talwar

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

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.