topic Complex Set Analysis : Differences between non-consecutives years in App Development

Complex Set Analysis : Differences between non-consecutives years

Hevel — Tue, 12 Oct 2021 09:39:29 GMT

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 !

Re: Complex Set Analysis : Differences between non-consecutives years

maxgro — Tue, 12 Oct 2021 10:04:59 GMT

Try with the after (or before) function

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

Re: Complex Set Analysis : Differences between non-consecutives years

Hevel — Tue, 12 Oct 2021 12:05:49 GMT

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 !