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.
