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

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

Anonymous — Tue, 24 Jan 2012 12:25:32 GMT

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

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

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

swuehl — Tue, 24 Jan 2012 12:35:51 GMT

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

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

Anonymous — Tue, 24 Jan 2012 12:39:28 GMT

thx, forgot those functions completely!!