topic Re: Calculate share on total grouped by another value in QlikView

Calculate share on total grouped by another value

Wed, 18 May 2011 14:39:28 GMT

Hello all,

I have the following data;

Product,Category,Value

A,X,46

A,X,89

B,X,69

B,X,62

C,X,84

C,X,65

D,X,1

D,X,64

E,Y,7

E,Y,4

F,Y,87

F,Y,20

G,Y,97

G,Y,30

H,Y,24

H,Y,63

I,Y,60

I,Y,2

J,Y,19

J,Y,51

As a result I want the next table.

The share is based on the total grouped by category, but i do not want the category in the table. Every product has one category.

see the atached QV example.

Can anybody help me out here, thnx in advance!!

Wed, 18 May 2011 15:03:46 GMT

Hi,

Find attached with the solution. You need to use the expression below.

Sum (Value) / aggr(NODISTINCT sum(Value),Category)

Please let me know whether this issue is resolved.

Best Regards,

Sajeevan

Wed, 18 May 2011 18:07:35 GMT

Thank you very much, this solves the problem!