Pareto chart in QlikView

Pareto chart in QlikView is used to represent what is driving your key metrics.

Pareto chart is also called 80/20 chart.

Pareto chart is basically a combo chart – combination of a bar chart and a line. It represents that 80% of the output came from 20% of the input.

Learn how to create a combo chart in QlikView 

Pareto Chart is useful in prioritizing the problem areas. It is one of the basic tools in quality control.

Steps to create Pareto Chart in QlikView :

1. I will load sample data for the Products and Complaints received on each product.

Pareto_data4

 

2. Select a combo chart on the general tab of the charts

3. Select Products as dimension

4. In the expression , use Sum(Complaints). This will be displayed as  bar. Make sure under Accumulation property check “No Accumulation”

5. Create another expression for % .   Sum(Complaints) / Sum( TOTAL Complaints). Make sure under Accumulation property check “Full Accumulation”

6. Under Sort tab – select Y-value Descending

7. Under Axes – For Complaints  –  under position property “Left bottom” and for % select “Right (Top)”

8. Chart will look like the one below

Pareto_Chart4

T-shirts and Gloves are driving more complaints than any other Products. By using Pareto chart management can quickly identify which Products need more attention.

 Further Reading: asq.org – Pareto Chart

2 thoughts on “Pareto chart in QlikView

  1. Jose Pascual says:

    Excelente!!! Gracias

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.