topic Re: Percentage Pivot table in QlikView

Percentage Pivot table

Wed, 25 Nov 2020 16:16:04 GMT

Hey, everyone!

I'm trying to solve this issue, but it's not working. see:

I have a Pivot table, where I have the total produced by machine and by product

	Machine A	Machine B	Machine C	Total Per Product
Product A	59	47	79	185
Product B	27	52	22	101
Product C	26	12	55	93
Total Per Machine	112	111	156	379

I want to show the respective percentage for each one of these (like that below):

	Machine A	Machine B	Machine C	Total Per Product
Product A	32%	25%	43%	1
Product B	27%	51%	22%	1
Product C	28%	13%	59%	1
Total Per Machine	30%	29%	41%	1

Can anyone help me, please?

Kind regards, Luiz Bisco

sunny_talwar — Fri, 23 Sep 2016 15:38:22 GMT

Try this may be:

Count(Measure)/Count(TOTAL <Product> Measure)

or if you are doing Sum, then this:

Sum(Measure)/Sum(TOTAL <Product> Measure)

Fri, 23 Sep 2016 16:16:07 GMT

Thank you for the attention, Sunny!

Ok, but It will give me the % of the general not by product by machine.

sunny_talwar — Fri, 23 Sep 2016 16:17:59 GMT

I think it should, let me create a small sample for you

sunny_talwar — Fri, 23 Sep 2016 16:21:22 GMT

Check this out

Fri, 23 Sep 2016 18:05:05 GMT

Sunny, can I make it inside a set analysis.

I'm trying to do something like that, I have to show only one process:

Sum( Total {$<

Process={'Extrusion'}

>} Measure)

sunny_talwar — Fri, 23 Sep 2016 18:07:31 GMT

Sure, may be like this:

If you want it in both numerator and denominator

Sum({<Process = {'Extrusion'}>}Measure)/Sum(TOTAL <Product> {<Process = {'Extrusion'}>}Measure)

If you want it only in denominator

Sum(Measure)/Sum(TOTAL <Product> {<Process = {'Extrusion'}>}Measure)

Fri, 23 Sep 2016 18:15:59 GMT

You're so smart, really! hahaha. Thank you very much!