Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

afuchten
Valued Contributor

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
MVP
MVP

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

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

2 Replies
MVP
MVP

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

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

afuchten
Valued Contributor

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

thx, forgot those functions completely!!

Community Browser