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.

       

      Daniel

       

      Week 1Week 2Week 3Week 4
      5687
      50555357
      8.3336.8757.571