Sum based on input boxes

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Sum based on input boxes

tresB — Mon, 26 Mar 2018 11:04:29 GMT

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)

Re: Sum based on input boxes

parthesh — Mon, 26 Mar 2018 11:12:13 GMT

can you provide qvw?

topic Sum based on input boxes in QlikView

Sum based on input boxes

Re: Sum based on input boxes

Re: Sum based on input boxes