Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Help with aggr function

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

3 Replies
Not applicable

Re: Help with aggr function

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

Hi,

If you use

aggr(sum(Production),Region,Class)

/

aggr(SUM(Production),Region)

for desire calculation then you get corrct value.

Rgds

Anand

Not applicable

Re: Help with aggr function

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