Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Partner
Partner

Full Accumulation Division

Hi guys, I have a table which has current amount and last year amount. And I want the % of the difference in a cummulative format.

If I need to do this in a chart table, I can do it using :

Rangesum( sum([Current Amount]),above( [Current Amount Acc] )) where "[Current Amount Acc]" is the label of the column.

But what if I need the calculation of the % in one single column? I want to do a lines table.

Here's what I have with qlikview :

1.png

And this is what I'd like to have :

2.png

Any ideas? Regards, Marcel.

Here you have my qlikview document.