Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

fheidenstecker
Contributor II

Above Function

Hi,

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

Above.png

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?

Cheers,

Fabian

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Above Function

Try with the TOTAL qualifier:

sum(Betrag)- above(TOTAL sum( Betrag ))

5 Replies
MVP
MVP

Re: Above Function

Try with the TOTAL qualifier:

sum(Betrag)- above(TOTAL sum( Betrag ))

Not applicable

Re: Above Function

try this

sum( Sales )  - above( sum( Sales ))

or this one

above( sum( Sales )) - sum( Sales ) 

Not applicable

Re: Above Function

PFA.

Hope it helps!

fheidenstecker
Contributor II

Re: Above Function

Thats was FAST!

Thanks swuehl and Shyamal Pandit

er_mohit
Honored Contributor II

Re: Above Function

See the attached file

Community Browser