Discussion Board for collaboration related to QlikView App Development.
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 :
And this is what I'd like to have :
Any ideas? Regards, Marcel.
Here you have my qlikview document.