topic AGGR Function - how to use in this case in QlikView

AGGR Function - how to use in this case

avastani — Fri, 06 Aug 2010 03:42:28 GMT

What expression would I use to remove the Region dimension and maintain the month-year and create a stack bar chart showing number of distinct Regions with Utilization in 3 custom buckets of <.75, .75<=x<0.9, >=0.9?

I tried the Aggr function and it does not display anything.

i tried

sum

(if(aggr($(veUtilization), Region, Country, [World Region],_MonthYear) < 0.75, 1, null())) and the similar for other buckets but it does not give the right results

no worries, i figured it out. I had Country and pWorld Region dimensions that did not belong in there. Interesting how the aggr function worked when i had it in there.

AGGR Function - how to use in this case

Fri, 06 Aug 2010 07:42:19 GMT

You don't nedd AGGR, just add a new dimension :

=if(V>0.9, 1 ,
If(V>0.75 , 2 , 3))

Expression : = count( distinct Region)

Don't forget to check Stacked Bar

Here an example

jjj

AGGR Function - how to use in this case

avastani — Fri, 06 Aug 2010 12:54:31 GMT

Interesting when I try your solution it doesn't work for me since it gives a message error in calculation for expression.

AGGR Function - how to use in this case

Sun, 08 Aug 2010 09:10:44 GMT

maybe problem with the comma ',' or the dot '.' .

Check your decimal setting.

JJJ