12 Replies Latest reply: Aug 18, 2017 7:15 AM by Sunny Talwar RSS

    How to calculate cumulative data in Qlik Sense?

    Ivan Yang

      Dear Qlik Sense Experts

       

      I am new to Qlik Sense and I am a front end user

       

      Now my raw data is as below. First line shows how many orders shipped in specific days

       

      Take [E2] as an example, it means there are 4 orders take 6 days to ship from plant

       

      Now I want to add 2nd line to calculate the cumulative orders which shipped within specific days

       

      Take [F3] as an example, there are 26 orders ships within 7 days

       

      These 26 orders include:

      1 order takes 5 days to ship

      4 orders take 6 days to ship

      21 orders take 7 days to ship

       

      So 26 [F3] = [B2]+[C2]+[D2]+[E2]+[F2]

       

      May I  know what expression I should use in Qlik Sense to make this request happen?


      捕获.PNG


       

      You could refer to raw data in attachment

       

      Thank you for your advice in advance

       

      Ivan