Pareto Select Using Multiple fields...

Tue, 10 Jan 2012 19:15:49 GMT

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...?

Pareto Select Using Multiple fields...

Oleg_Troyansky — Tue, 10 Jan 2012 19:35:19 GMT

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?"

topic Pareto Select Using Multiple fields... in QlikView

Pareto Select Using Multiple fields...

Pareto Select Using Multiple fields...