topic Re: multiply total in a Pivot table in QlikView

multiply total in a Pivot table

Anonymous — Thu, 16 Feb 2017 00:59:53 GMT

Hello,

I have a pivot table which has two dimensions, products, process_group and four expressions, Input, Defect FPY and KDPM.

Now I would like to create one more column which is the term of multiplication of all three FPY under each DIP, FA and SMT dimensions.

For example,

The red box is what I want add to this pivot table, and it is the term of all FPY. i.e. 98.85%*100.00%*97.87%=98.69% for SMA200.

How to do this?

thanks,

Josh

Re: multiply total in a Pivot table

Anonymous — Thu, 16 Feb 2017 01:01:18 GMT

Oh, btw, Input, Defect, FPY and KDPM are all expressions in the pivot table.

Josh

Re: multiply total in a Pivot table

satheshreddy — Thu, 16 Feb 2017 02:11:54 GMT

Hi Josh,

write the exp in expressions tab you can achieve.

Regards

Sathish

Re: multiply total in a Pivot table

sunny_talwar — Thu, 16 Feb 2017 10:00:00 GMT

So in way you are looking for a total for FPY and NOT the same number (98.69%) repeating under each process_group (DIP, FA, SMT)? or do you want a same number repeating under each process_group?

Re: multiply total in a Pivot table

Anonymous — Thu, 16 Feb 2017 17:47:28 GMT

Sunny,

Not repeating under each process_group.

And, I want to reuse the expression FPY to calculate the multiplication of DIP.FPY * SMT.FPY * FA.FPY.

Thanks,

Josh