topic Re: Sum() in the If Condition in QlikView

Sum() in the If Condition

markgraham123 — Tue, 05 Jan 2016 15:13:05 GMT

Hi all,

I was trying to sum the filed grouped by name in the if loop.

=If(Status=1,Sum(Aggr([Amount],Name)))

This is not giving any result.

Can someone please help here

Re: Sum() in the If Condition

sunny_talwar — Tue, 05 Jan 2016 15:16:03 GMT

May be this:

Sum({<Status = {1}>} Aggr(Only({<Status = {1}>} Amount), Name))

Re: Sum() in the If Condition

markgraham123 — Tue, 05 Jan 2016 15:18:14 GMT

It's just giving 0 sunny.

Re: Sum() in the If Condition

sunny_talwar — Tue, 05 Jan 2016 15:20:20 GMT

Would you be able to share a sample?

Re: Sum() in the If Condition

kkkumar82 — Tue, 05 Jan 2016 15:21:16 GMT

Can you put some dummy data.

Thanks

Kiran Kumar

Re: Sum() in the If Condition

Anonymous — Tue, 05 Jan 2016 15:23:11 GMT

Hi Mark,

Please try:

Sum(Aggr(Sum({<Status = {1}>} Amount), Name))

Re: Sum() in the If Condition

markgraham123 — Tue, 05 Jan 2016 15:26:34 GMT

!Here is the sample application..

I was trying to do the calcualtions using the variables.

Re: Sum() in the If Condition

Anonymous — Tue, 05 Jan 2016 15:26:53 GMT

Hi Mark,'

Only function returns 0(Zero) if they is more than one value for a dimension

Regards

Neetha

Re: Sum() in the If Condition

sunny_talwar — Tue, 05 Jan 2016 15:30:12 GMT

I see this:

Re: Sum() in the If Condition

markgraham123 — Tue, 05 Jan 2016 15:39:46 GMT

Sunny its working for me.

Also, i'm trying to store the value of the Column's total in chart to a variable...

I can do it by storing the expression in Variabloe.

But due to req. constraints i wanna do it the other way.

Can we do it?

Re: Sum() in the If Condition

markgraham123 — Tue, 05 Jan 2016 15:43:02 GMT

Thanq neeta.

It worked

Re: Sum() in the If Condition

sunny_talwar — Tue, 05 Jan 2016 16:16:43 GMT

Is this going to change based on selections?