Pareto analysis with Set analysis

breukelaarj — Fri, 04 Jul 2014 09:25:04 GMT

Hello,

I'm creating a chart that sums the spend per vendor.

Next I'm applying a set pareto action. This way I can drill down to show the largest contributors to the overall spend.

A tekst box is displaying the percentage of contribution.

This works great for the whole data set.

So to get the percentage I'm using the sum(spend) / sum(total spend) (the real equation is a bit more than that but this is for demo purposes).

The spend encompasses many years. So a user might want to select a specific year. Now I'm in trouble as the TOTAL part of the equation is not taking into account my selection.

So how do I combine the selection with the total. Meaning the total spend of the selected year versus teh pareto action that takes a percentage of the sum(spend)

Hope someone can hjelp me out.

Kind regards

Johan Breukelaar

topic Pareto analysis with Set analysis in QlikView

Pareto analysis with Set analysis