specific pivot feature

[Anonymous]

hello everybody.

i have this data set: shops and their sales per year. i'd like to create a pivot chart showing the sales per shop/year AND the differences (absolute and percent) between consecutive years. see the followng image: image (Excel example):

thanx

[Anonymous]

that's it! do you think it could be possible to set it iterative? i.e.:

• let's assume today is 7/1/2022 (the 7th of January year 2022);
• the date of the first record is 4/5/2011 (the 4th of May 2011)
• we have 2022-2011+1 = 12 years passing through
• instead of writing sum({<year = {$(=max(year)-2)}>}sales) ... could Qlik manage something iterative to create expressions automatically for each year recorded?.

thanx, bye