Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage Pivot table

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 AMachine BMachine CTotal Per Product
Product A594779185
Product B275222101
Product C26125593
Total Per Machine112111156379

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

   

Machine AMachine BMachine CTotal Per Product
Product A32%25%43%1
Product B27%51%22%1
Product C28%13%59%1
Total Per Machine30%29%41%1

Can anyone help me, please?

Kind regards, Luiz Bisco

1 Solution

Accepted Solutions
sunny_talwar

7 Replies
sunny_talwar

Try this may be:

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

or if you are doing Sum, then this:

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

Not applicable
Author

Thank you for the attention, Sunny!

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

sunny_talwar

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

sunny_talwar

Check this out

Capture.PNG

Not applicable
Author

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

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)

Not applicable
Author

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