topic Re: Help with aggr function in QlikView

Help with aggr function

Tue, 18 Oct 2011 09:37:08 GMT

Hi all,

I am new to QV and need your help with the following issue:

I am using a Mekko chart in order to show the distribution of production per region per class (class of production).

The problem is when I check the “Relative” checkbox, the distribution is done based on the total production from all regions, and not per region as desired.

I was able to use the aggr function in order to sum the production by region, but I wasn’t able to calculate the production by class and region.

I’ve attached a file with the desired outcome and the outcome I get now.

I would appreciate your help,

Thanks,

Maya

Re: Help with aggr function

Mon, 24 Oct 2011 10:49:21 GMT

Hi,

I have used drill down group for the dimentions(region and class). Click on any Region it ll show its corresponding class's production hope it ll help u.

Just see the attachment.

Re: Help with aggr function

its_anandrjs — Mon, 24 Oct 2011 11:08:36 GMT

Hi,

If you use

aggr(sum(Production),Region,Class)

aggr(SUM(Production),Region)

for desire calculation then you get corrct value.

Rgds

Anand

Re: Help with aggr function

Mon, 24 Oct 2011 11:53:53 GMT

Hi,

First, thanks for the help.

It did not work properly...

Now it shows only one class ("Not specified") per region.-Each region gets the % in that specific class (("Not specified")- the result is not correct either.

Any ideas?

Thanks,

Maya