Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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!