topic Re: Aggr function? in QlikView

Aggr function?

Thu, 28 Feb 2013 14:27:11 GMT

Hi,

I have following table:

X,Y

A,1

A,2

A,3

B,1

B,2

C,2

C,3

The result that I am looking for is an aggregation/subtotal in every row in a new column:

X,Y,Z

A,1,6

A,2,6

A,3,6

B,1,3

B,2,3

C,2,5

C,3,5

Furhtermore I am looking for the calculation of the shares:

X;Y;Z;XY

A;1;6;0,16

A;2;6;0,33

A;3;6;0,5

B;1;3;0,33

B;2;3;0,66

...

Could somebody please help me solving this issue?

Thank you verry much.

Kind regards,

Andi.

Re: Aggr function?

hic — Thu, 28 Feb 2013 16:08:00 GMT

You don't need to change the script at all. And you don't need an Aggr() function or Set analysis. Just load your initial data and then make a chart like this:

HIC

Re: Aggr function?

Fri, 01 Mar 2013 08:13:47 GMT

Thanks a lot for your help.

I am almost there.

In my case the table looks now like this.

The problem is that a wagon number appears more than once depending on the date. What kind of formula do I need to sum "Länge" for the separate dates?

60, 20, 40 and not 120.

I need 2 criteria: "Waggonnr." and "Übernahmedatum"

Thank you.

Re: Aggr function?

hic — Fri, 01 Mar 2013 08:20:50 GMT

Sum(total <Übernahmedatum,Wagonnr.> Länge)

HIC