Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
kstamab
Contributor
Contributor

How to create a table that calculates week on week difference

Hello all,

I want to create a table that calculates the differnece in sales from week 1 to week 2 etc per product axis and make it either dynamic ( weeks appear as new data enter) or static. 

My data are in this format. I have the Code, week number, the product axis and few metrics.

 

image.png

 

I wish to end up in a table to report as such: 

kstamab_0-1622967689011.png

where delta sales in week 2 is calculated as such: week 2 - week 1, for week 3: week 3 - week 2 and week 4: week 4 - week 3.

 

Is that possible to be achieved in Qlik Sense?

 

Any help is much appreciated! 

 

PS. I have attached an excel file with the above data if that helps!

Labels (1)
0 Replies