This content has been marked as final. Show 3 replies
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.
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
Thank you for the help,