Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a question regarding the Above Function. I want to calculate the difference between the current line and the previous one.
I expect the result to be as in this Excel Table
I simply can't get it to work. The problem I think is the rowno starts again at 1, because there are 2 different years (2012,2013)
Does anybody have an idea how to solve this?
Go to Solution.
Try with the TOTAL qualifier:
sum(Betrag)- above(TOTAL sum( Betrag ))
sum( Sales ) - above( sum( Sales ))
or this one
above( sum( Sales )) - sum( Sales )
Hope it helps!
Thats was FAST!
Thanks swuehl and Shyamal Pandit
See the attached file