Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
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
0 Replies