Compare Sales of Current Year with Sales of Previous Year

[holymosfet]

Hi all,

it's driving me crazy and I found dozens of posts that all bring up the same solution that won't work for me.

I'm trying to compare the Sales with the Previous Year's Sales. Does anyone know why I don't get the correct numbers?

Any help is much appreciated.

[Clement15]

Hello, if it is for a table you can use this formula :
Above(sum(Sales))

[anat]

use above(sum(sales)) for previous year sales 

[holymosfet]

Hi Anat,

thank you for your reply. The above() function only works on row level in the diagram. If I add other dimensions it won't work.. 😞

Any idea why 

Sum({$<Year={$(=max(Year)-1)}>} Sales)

does not work?

[paulcalvet]

Hello,

It doesn't work because in Qlik a variable in set analysis is the same for each line in your table.

In your case the variable is always set to 2022, that's why only the line for 2022 is filled.

In table you must use above.

Regards,