0 Replies Latest reply: Jan 31, 2017 4:38 PM by Daniel Henslee RSS

    Help with formula - possibly similar to rolling periods

    Daniel Henslee

      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.




      Week 1Week 2Week 3Week 4