Complex Set Analysis : Differences between non-consecutives years

[Hevel]

Hello dear Qlik Community,

My need is pretty simple.

Here I have a pivot table displaying some sales through years I have pre-selected in a filter.

I would like to create a column that calculates the difference between the "dimensional" year and the year that falls behind among the current selected years. 

Something like that :

Finally, and ideally, I would add a conditional statement to hide this column if the "dimensional year" is the last one ( there's no previous year to calculate differences with).

I've tried something with the max and rank functions to identify the previous selected year, but I'm not an expert with set analysis and this case is beyond my current skills.

Thank you for you help !

[maxgro · Accepted solution]

Try with the after (or before) function

Sum(Sales) - After(Sum(Sales)) 

[Hevel]

Incredible, I can't believe it works and it was so simple. I'll try to learn more about the inter-record functions in Qlik. 

Thank you !