topic Re: Multiple Criteria in Sum expression in QlikView

Multiple Criteria in Sum expression

ivanaksen — Wed, 15 Aug 2018 12:19:18 GMT

Hello everybody,

Please support with the bellow issue:

in Visualization I need to see percentage of data with the condition Aging> than 89 days, and I have the formula, which is not correct working, it`s showing only 1, like I dont have filter [Aging]={'>89'}:

sum({<[Aging]={'>89'}>}Amount.Loc)/Sum([Amount.Loc])

But all data is in Raw data table is correct with aging.

I tried to make the formula in script: sum(If(Aging>89,([Amount.Loc]))) as Aging_delay_Amount,

but again I have an error there.

please advise

Re: Multiple Criteria in Sum expression

sunny_talwar — Wed, 15 Aug 2018 12:23:05 GMT

How about if you try this with double quotes?

Sum({<[Aging] = {">89"}>} [Amount.Loc])/Sum([Amount.Loc])

Re: Multiple Criteria in Sum expression

ivanaksen — Wed, 15 Aug 2018 12:31:35 GMT

Thanks a lot, finaly it works

Re: Multiple Criteria in Sum expression

sasiparupudi1 — Wed, 15 Aug 2018 12:31:59 GMT

May be change your script expressi to aflag

sum(If(Aging>89,([Amount.Loc]))) as Aging_delay_Amount,

If(Aging>89,1,0)) as Aging_delay_flag

in the chart

Sum({<[Aging_delay_flag] = {1}>} [Amount.Loc])

btw, did you check if your field value a number or a string?

Re: Multiple Criteria in Sum expression

ivanaksen — Wed, 15 Aug 2018 12:41:30 GMT

This works good, too thank you