Aggr function including IF statement

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

Hey all

Wondering if what I'm trying to do is possible.

In the third expression below I would like to count all free units per BIL_ID, but doing so by month. Obviously it works if I replace the Date_MonthYear dimension with BIL_ID... But I would like to see that per month instead.

So, I've tried this expression using the Aggr function, but that doesn't work:

=Aggr(If(Sum(NetRevenue)=0, Sum(Quantity), 0), BIL_ID)

Is it possible to do what I'm trying to do in this way?

Thank you for your help!

Re: Aggr function including IF statement

sunny_talwar — Thu, 08 Nov 2018 14:16:18 GMT

Try this

Sum({<BIL_ID = {"=Sum(NetRevenue) = 0"}>}Quantity)

Re: Aggr function including IF statement

Anonymous — Thu, 08 Nov 2018 14:39:45 GMT

That works! Thanks a lot Sunny

topic Re: Aggr function including IF statement in QlikView

Aggr function including IF statement

Re: Aggr function including IF statement

Re: Aggr function including IF statement