topic Re: Re: Pivot table help in QlikView

Pivot table help

Tue, 07 Jan 2014 12:15:51 GMT

Hi All,

I have a requirement where I need to display a Pivot table having dollar values for the following values of one Dimension.

Product1	Amount
Sales	76215.5
Direct	52044.86
Indirect	89573.6
Marketing	93449.1
Direct	6554.309
Indirect	19710.01
Product2	41871.07
R&D	26531.7
Direct	48975.56
Indirect	48590.39

and so on.

The problem that QlikView sees the repeating values in the Dimension and clubs them all together, so my Pivot table looks like the following:

Product1	Amount
Sales	49825.05
Direct	172573.6
Indirect	253675.1
Marketing	11201.1
Product2	66014.51
R&D	86477.5

The values of Direct and Indirect are being summed up and shown in one row respectively.

How can I make QlikView show it as individual values in the Pivot chart??

Thanks,

Abhinava

Re: Pivot table help

Tue, 07 Jan 2014 14:33:02 GMT

I could be wrong, but if you're loading these tables with two instances of the same name I don't believe there is any way to differentiate them as Qlikview sees them as the same. If possible I would just say change the way they are labeled?

Re: Pivot table help

Anonymous — Tue, 07 Jan 2014 19:06:48 GMT

Correct, the fields with the same name in QlikView is the same field.

Re: Pivot table help

maxgro — Tue, 07 Jan 2014 20:55:21 GMT

I agree but with some tricks maybe you can get the pivot or something similar to the request; my result is

Regards

Re: Pivot table help

iktrayanov — Tue, 07 Jan 2014 21:01:40 GMT

You probably have a design problem. Can you show your load script?

Re: Pivot table help

maxgro — Tue, 07 Jan 2014 21:09:02 GMT

Tmp:

load recno() as rn, *;

LOAD * INLINE [

Product, Col2, Amount

Product1, Sales, 76215

Product1, Direct, 52044

Product1, Indirect, 89573

Product1, Marketing, 93449

Product1, Direct, 6554

Product1, Indirect, 19710

Product2, R&D, 26531

Product2, Direct, 48975

Product2, Indirect, 48590

];

Re: Re: Pivot table help

iktrayanov — Tue, 07 Jan 2014 21:14:45 GMT

See attached.

Re: Re: Re: Pivot table help

iktrayanov — Tue, 07 Jan 2014 21:18:22 GMT

Or if you want just one dimension see this

Re: Pivot table help

maxgro — Tue, 07 Jan 2014 21:29:42 GMT

Hi Ivan, try a dummy column as in my attachment