topic % calculation based on 2 dimensions in QlikView

% calculation based on 2 dimensions

lmonincx — Thu, 16 Jul 2009 22:09:36 GMT

Hi,

I am try to establish in a straight table with two dimensions Naam and Hyp to get a % of the counter .

data:

Naam Hyp Counter

Linda Eerste 18

Isabel Eerste 22

Edward Tweede 50

-----------

so total of 90

The expression must first get a total on Hyp level like Eerste on 40 and then calculate on Naam level like Linda the % of Linda's Counter in regards to the total within the same dimension level.

Expected outcome should be 45 % ( 18 out of 40)

Any idea how to do this?

Regards,

Linda

% calculation based on 2 dimensions

Thu, 16 Jul 2009 23:25:34 GMT

You should be able to create that Expression using the Aggr() function (Page 353 in Book II of the Reference Manual).

Sum(Counter) / aggr(nodistinct Sum(Counter), Hyp)

I've attached the sample.

% calculation based on 2 dimensions

lmonincx — Fri, 17 Jul 2009 01:28:40 GMT

Many thanks that worked!