topic Creating a pareto Chart in QlikView

Creating a pareto Chart

Tue, 10 Jul 2012 07:04:05 GMT

Hi All,

Please can anybody help me for making a Pareto chart??

I have 4 dimensions along which a measure is being calculated. Then I have calculated the relative Percentage of this measure. Now I want to perform a cumulative sum of this Percentage and plot in a graph/ a straight table. The problem lies in calculating cumulative sum of relative %.

Re: Creating a pareto Chart

giakoum — Tue, 10 Jul 2012 07:09:16 GMT

It is easy to do now in QV11. Just use Dimension Limits in the chart properties.

Re: Creating a pareto Chart

jagan — Tue, 10 Jul 2012 08:58:26 GMT

Hi,

Try using Pareto Select Action in "Actions" of Button properties. Check attached file for solution.

If you are QV11 then you can do this by setting a property in Dimension limits tab of Chart properties. Check attached screenshot.

Regards,

Jagan.

Re: Creating a pareto Chart

Tue, 10 Jul 2012 12:24:03 GMT

Thank you for the above solutions but they dont work for my problem. I will explain in detail. I have 4 dimensions then I calculate a measure which is the difference between dates i.e ans is no of days(Diff). Now this measure is further divided by standard no of days say it is called 'error'. Now i have to build a pareto chart of this data.