Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

specific pivot feature

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):

Qlik_PVT.JPG.jpg

thanx

10 Replies
Anonymous
Not applicable
Author

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