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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pareto Select Using Multiple fields...

I'm not even sure if this can be done, but I figured if anyone knew how, it would be this group.  I have a button that performs a pareto select based on Vendor and Spend to find the top 80% of spend by Vendor.  However, I also have a category field and I'd like to be able to perform the pareto in order to find the Top 80% of spend, by supplier, per Category.  Is there a way to add the category field into the mix, either through the field and/or expression, to force it to group by the category first, perform the 80% selection and then go to the next category and so on...? 

1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

If you create another field as a combination of Suppler and Category, then you can use the new field to get the 80% of spend by Supplier and Category.

On the other hand, if you wanted to apply your Pareto Selections separately, you could have 2 buttons - one for Supplier Pareto Select, and another one for Categories Pareto select. Then, the result will be someting like this:

"What Categories make up 80% of spend within the population of Suppliers that account of the 80% of the total spend?"