topic Pareto diagram in QlikView

Pareto diagram

Mon, 31 May 2010 12:54:42 GMT

Hi,

I am looking for the solution to build Pareto diagram (link, how it should look is HERE).

So far I have created combo chart with split axis, which looks like pareto diagram...

But the distance between the upper and lower graph is too great - is it possible to change the distance between them?

Does anyone have any other solutions for drawing pareto graph?

Kind regards,

Miha

Re. :Pareto diagram

martin59 — Mon, 31 May 2010 13:31:18 GMT

Hi,

Have you tryed to deactivate the "split axis" option and keep your 2 axis?

Re. :Pareto diagram

Mon, 31 May 2010 13:47:08 GMT

Hi,

If I remove split axis, this is the situation:

The problem is that the second measure is in percentage, and the first is in million €, also I need line graph above the bar chart...

Kind regards,

Miha

Re. :Re: Re. :Pareto diagram

martin59 — Mon, 31 May 2010 13:49:42 GMT

Right,

You have to fix you max value, send me your expressions and I'll help you 😉

Re. :Re: Re. :Pareto diagram

Mon, 31 May 2010 13:58:44 GMT

The situation is the following:

1. expression is SUM(Sales) - no accumulation

2. expression is SUM(Sales) / SUM(total Sales) - FULL ACCUMULATION, percentage

I have tried with bar offset, but was unable to do any good 🙂

thanks,

Miha

Re. :Re: Re. :Re: Re. :Pareto diagram

martin59 — Mon, 31 May 2010 14:29:41 GMT

right,

You have to do that :

1. For the first expression : Fix the static max value of your axe with this expression :

Max(aggr(sum(Sales),Dimension))

2. For second expression

Static min = Max(aggr(sum(Sales,Dimension))/sum(Sales)

Static max = 1

3. Adjust your Numbers format settings

Is that helps you ?

Re. :Re: Re. :Pareto diagram

Or — Mon, 31 May 2010 14:36:39 GMT

I have a different take on creating a Pareto chart - created using a guide for ABC charts posted in one of the QV blogs a few months back (Sorry, I forget which, so I can't credit the author). This uses one expression for the bars, one identical but cumulative expression for the line, and three more for the standard percentages - 80, 95, and 100 (these can be modified using parameters). Unlike yours, it doesn't display specific percentages - if you need that part, you'll have to look elsewhere for a solution.

Hope this helps.

Re. :Re: Re. :Re: Re. :Pareto diagram

Tue, 01 Jun 2010 07:59:01 GMT

Martin,

This is the thing I was looking for, yes 🙂

Thank you both,
Miha