Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
linxili10
Contributor II
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
tresesco
MVP
MVP

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)

parthesh
Creator
Creator

can you provide qvw?