topic Calculating from dynamic columns in pivot view in QlikView

Calculating from dynamic columns in pivot view

pritam251 — Wed, 10 Oct 2012 23:17:56 GMT

Hi,

I am trying to use pivot view to get a report in a desired format.

Initial Pivot Table:

Name || Date || Value

A 1 Oct 40

2 Oct 20

3 Oct 50

B 1 Oct 30

2 Oct 10

3 Oct 60

I pull the date above to the columns to have a view like this:

Name Date 1 Oct 2 Oct 3 Oct

A 40 20 50

B 30 10 60

How do I get an % with respect to total value of the names for that date, i.e when name is A and date 1st Oct the desired value is 40/(40+30) = 0.5714

A on 2nd Oct = 20/(20+10) = 0.66

Re: Calculating from dynamic columns in pivot view

Thu, 11 Oct 2012 03:42:10 GMT

Hi,

Maybe you could try this one.

Regards,

Janzen

Re: Calculating from dynamic columns in pivot view

Thu, 11 Oct 2012 06:02:10 GMT

Hai ,

I am attaching the same file of Janzen with little modifications.

It may helps you ,Please find it

Thanks ,

Rathish

Re: Calculating from dynamic columns in pivot view

pritam251 — Thu, 11 Oct 2012 16:24:22 GMT

Thanks, This definitely helps.

The only thing which I am stuck with is to get a generic function out of it because I have several such names and dates (i.e Names: A,B,C,D,E.... and so on Dates: 1st Oct, 2nd Oct, 3rd Oct, 4th Oct... and so on).

What I am trying to build is a date wise percentage aggregator.