3 Replies Latest reply: Feb 12, 2018 3:46 PM by Jahanzeb Hashmi RSS

    Sum based on selected month

    Andreas Verykokos

      Hello everyone,

       

      I am new to Qlik Sense and i am trying to understand some basics.

       

      I have the table shown below and i want to write an expression that gives me the sum of the "QTY" field starting from month number 1 until the number of month that will be given by the user.

       

      So if the user wants to see the the aggregated quantity from Jan to Jun, he should be able to choose june (month number 6) and the formula should be able to calculate the sum of "QTY" from jan to jun.

      Screen Shot 2018-02-11 at 10.35.27 AM.png

       

      Basically i want to create a front end whereby the user chooses the month and the system is calculating values like "QTY" from month 1 until the chosen month, then i will use the result of the expression to update charts like the waterfall chart shown in the picture below

       

      Screen Shot 2018-02-11 at 10.51.16 AM.png

       

      Thank you for the help,

      Andreas