Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

expression between previous and current Year . . . should I use Last() ??

I have a pivot table containing 1 expression which contains a number of transactions.

Now I want to create a second expression (last) which contains a percentage with the difference between the current number of transactions with the previous number of transactions

e.g. the number of transactions of year 2011 - 2010 / 2010 - 2009 / 2009 - 2008

TEST.png

I did try some stuff with the function Last() but this needs a fixed offset ... is there a way of using this function and take the previous value??

thx in advance!!

Anita

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You may probably want to look into the other chart inter record functions, like before() and in your case, after().

(or above() and below() for looking one row above or below).

Hope this helps,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

You may probably want to look into the other chart inter record functions, like before() and in your case, after().

(or above() and below() for looking one row above or below).

Hope this helps,

Stefan

Anonymous
Not applicable
Author

thx, forgot those functions completely!!