topic Pivot table Set Analyis Problem in QlikView

Pivot table Set Analyis Problem

Mon, 11 Jan 2010 11:40:15 GMT

Hi,

I use a pivottable that looks like this:

salesperson s1 s2 s3
group
a1 10 20 30
a2 20 30 40
a3 30 40 50

I'd like to show a percentage for each salesperson over all salespersons for each group.
e.g.

s1 %s1
a1 10 16% (10/60)

how can I set this up.

tried with set analysis but failed. sum(amount) / sum({salesperson=}amount)

Someone an idea?
Thanks.

Aloah

Pivot table Set Analyis Problem

Mon, 11 Jan 2010 12:24:23 GMT

Hi Aloah,

see the attached example.

Good luck!

Rainer

Pivot table Set Analyis Problem

Miguel_Angel_Baeyens — Mon, 11 Jan 2010 12:24:42 GMT

I'd try something like

Sum(amount) / Sum({< group = {"groupname"} >} amount)

Pivot table Set Analyis Problem

Mon, 11 Jan 2010 12:37:14 GMT

Hi Rainer,

thanks for your help. works perfectly. Can you explain me what "<group>" causes so that the formular works?

Aloah

Pivot table Set Analyis Problem

Miguel_Angel_Baeyens — Mon, 11 Jan 2010 12:57:15 GMT

Hello Aloah, "<group>" references the name of the dimension or column.