topic set analysis with aggr function in QlikView

set analysis with aggr function

dasaradh — Mon, 23 Nov 2015 14:21:35 GMT

I am creating variable called guarantee customer

vExpGuaranteecustomers=sum(aggr(if({<"sum({$1})">}={"<=$2"},1,0),CustomerNbr))

and i am using this variable $(vExpGuaranteecustomers(BalanceEur,100000))

but its returning 0

for example a customer has 4 accounts

if he had balance in his accounts less than 100000 he is guarantee customer other wise he is non guarantee customer

so that i am using aggr function like this

sum(aggr(if(sum(BalanceEur)<=100000,1,0),CustomerNbr))

above expression is working correctly how can i make it globally.

so here balanceEur and 100000 changes country wise i want to make it globalize.

can you help me in this.

thanks in advance.

Thanks,

Dasaradh

mohitd910 — Tue, 24 Nov 2015 07:35:25 GMT

Hi Dasaradh,

you have to create only variable for sum(BalanceEur) and use that in the expresion it will work as globally.

use that variable in this instead of sum(BalanceEur)

sum(aggr(if(sum(BalanceEur)<=100000,1,0),CustomerNbr))

dasaradh — Mon, 30 Nov 2015 10:24:09 GMT

I got ans like this

sum(aggr(if(sum($1)<=$2,1,0),CustomerNbr))

in this how can i add another varibale in if clause