topic aggr using an 'if-dimension' in QlikView

aggr using an 'if-dimension'

pennetzdorfer — Mon, 17 Dec 2012 13:21:15 GMT

Hey,

I have got the following aggr-function which returns the Sales for the best Sales representative:

max(aggr(sum(Sales),SalesRep))

Now I would like to replace the dimension value with an if statement:

max(aggr(sum(Sales),if(Variable=1,SalesRep,Region)))

Obviously that expression isn't valid. Do I miss something?

Regards,

Florian

Re: aggr using an 'if-dimension'

Anonymous — Mon, 17 Dec 2012 13:44:10 GMT

Hi did u try

f(Variable=1,

max(aggr(sum(Sales),SalesRep)),

max(aggr(sum(Sales),Region)))

Re: aggr using an 'if-dimension'

pennetzdorfer — Mon, 17 Dec 2012 13:46:59 GMT

Replacing the if-Condition with a variable doesn't work either.

Please find the attached qvw.

Re: aggr using an 'if-dimension'

fosuzuki — Mon, 17 Dec 2012 13:59:04 GMT

Check the attached qvw.

Hope this helps you

Fernando

Re: aggr using an 'if-dimension'

pennetzdorfer — Mon, 17 Dec 2012 14:00:44 GMT

alfasierra, thanks for your suggestion, I agree.

But: I posted a rather simplified example to demonstrate the basic problem. In my real application I have several possible dimension values (such as SalesRep, Region ...) and some other if conditions. Plus, I'm using similar expressions in a couple of objects --> thus I would like to keep them as simple as possible.

I'm wondering why the if-condition doesn't work as supposed.

Regards, Florian

Re: aggr using an 'if-dimension'

pennetzdorfer — Mon, 17 Dec 2012 14:03:38 GMT

That works!! Thanks Fernando