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.
I wish to end up in a table to report as such:
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!