Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
andreasverykoko
Contributor
Contributor

Sum based on selected month

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

3 Replies
Digvijay_Singh
Master III
Master III

The expression should me something like this -

Sum({<Month={">=1<=6"},Month=>}QTY)

But it depends on your data model, how your date/month etc fields are defined, formatted and associated with other data.

Anil_Babu_Samineni

Not entirely sure, Why Waterfall chart for this requirement. Can you share some data points from your model?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
zebhashmi
Specialist
Specialist

you can use an input box for Variable and pass the veritable to expression as qlik sense do not have input box you can do that with extension

Input box in qlik sense