Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Help with formula - possibly similar to rolling periods

I'm new to Qlik Sense and have been doing a lot of searches on this site and others as well as YouTube.  Really enjoying it but I've hit a wall in my still developing set analysis skills.

What I'm looking to do is find a way to get row 3 to calculate the following

Current Week Row 2 / Next Week Row 1

50 / 6 = 8.333

55 / 8 = 6.875

Ultimately I'm trying to get to a simple Days of Supply calculation.  I will add to the final results but it's this issue of Current Week Divided by Following week that is tripping me up.  Any help would be greatly appreciated!  Thank you in advance.  Looking forward to learning more Qlik Sense and browsing the boards.

Daniel

Week 1Week 2Week 3Week 4
5687
50555357
8.3336.8757.571