Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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