topic Re: Pivot Table question in QlikView

Pivot Table question

salto — Mon, 24 Jul 2017 11:29:25 GMT

Hello,

I have a pivot table in which I would like to add the '%' line:

Item	Value	Header 3
Item A	sum(Amount) = 375
Item B	sum(Amount) = 125
Item C	sum(Amount) = 100
%	(Item C) / (Item A)
Item D	sum(Amount) = 250

Is it possible, in the pivot table, to get the value of items A and C to perform the calculation?

Thanks in advance for your help.

Re: Pivot Table question

Anil_Babu_Samineni — Mon, 24 Jul 2017 11:32:37 GMT

How many Items you have?? Will you able to provide some data set to check?

Re: Pivot Table question

arvind_patil — Mon, 24 Jul 2017 11:35:57 GMT

Agree with you require sample data.

Thanks,

Arvind Patil

Re: Pivot Table question

rahulpawarb — Mon, 24 Jul 2017 12:02:08 GMT

May be this:

Data:
LOAD * INLINE [
Item, Value
Item A, 375
Item B, 125
Item C, 100
Item D, 250
];
Concatenate
LOAD '%' AS Item,
     Num(Sum(If(Item='Item C', Value, 0)) / Sum(If(Item='Item A', Value, 0)), '#,##0.##%') AS Value
Resident Data;

Regards!

Rahul Pawar

Re: Pivot Table question

Nagaraju_KCS — Mon, 24 Jul 2017 12:09:24 GMT

PFA,