Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

How to develop this report in pivot table

How to develop Cumulative percentage calculation.

 

 JanFebMarAprTotalCummulative
A234567267636170432%
B246356167542131157%
C6832686436992293100%

 

 

6 Replies
Highlighted

Re: How to develop this report in pivot table

Anyone has an idea for this report

Highlighted

Re: How to develop this report in pivot table

What is your expression you use? Do you have a sample we can look at?

Highlighted

Re: How to develop this report in pivot table

Hi Sunny,

Attached is the data you can use that one

 

Dimension1:- Dealer

Dimension2:- Month 

Expression:-Sum(Value)

Highlighted

Re: How to develop this report in pivot table

So, you are looking to have an additional column with %?

Highlighted

Re: How to develop this report in pivot table

Yes right expression is 

 

Expression :- Sum(Total Value) / Sum(Value)

Highlighted
Digital Support
Digital Support

Re: How to develop this report in pivot table

Best I have is the following Design Blog post, not sure if I am missing something or not, hopefully it may help:

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

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.