Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor II

Sum based on input boxes

I'm trying to create a model to give a sum per customer/SSN based on the value in input boxes. The reason why I'm trying input boxes is to see how the distribution changes, depending on the value I give in the range of 1-10.

I've created input boxes like varA, varB, varC etc.

The expression in my table is somewhat like

Sum(Aggr

((if,Flag1=1,VarA,0),

if(Flag2=1,VarB,0),

if(Flag3=1,Var3,0),

SSN))

All the Flags have either 1 or 0 as a value. My goal is to flag the SSNs which receives a sum of Vars >= 10.

So far this doesn't work, and I'm not sure if I'm able to really explain what I want. I haven't tried this approach with input boxes before, and I'm unsure if this is the best sollution. Google has so far not been my best friend, hoping some of you great minds can put me in the correct way of thinking/googling

2 Replies
Highlighted
MVP
MVP

Re: Sum based on input boxes

Not really if I understood. I would rather create one input box with one variable expecting value 1-10. That is one value at a time. Then use the variable in the expression like:

Sum({<YourField={">=$(yourVariable)"}>}SSN)

Highlighted
Contributor

Re: Sum based on input boxes

can you provide qvw?