7 Replies Latest reply: Mar 22, 2018 1:02 PM by Yianni Ververis

# Pareto chart in Qlik Sense

Is it possible to construct a Pareto Chart in Qlik Sense?

E.g. in a combo chart show sales of categories in columns sorted descendingly and the cumulative proportion of total sales shown as a line. Preferably with a drop line at the intersection of 80%.

Regards,

Ulrik

• ###### Re: Pareto chart in Qlik Sense

Hi Ulrik,

Assume we have a data source with this fields : Product / Qty

1- Make a combo chart with

- Dimension -> Product

- Measure -> Sum(Qty)

- Measure -> Accumulation % formula : RangeSum(Above(Sum(Qty), 0, RowNo())) / Sum(TOTAL Qty)

- Measure -> 80 % line formula : 0.8

Set the Accumulation % and the 80% line as Line charts on the secondary axis with a "# ##0%" number format.

2- Sort by Product (decrease) with a formula : Sum(Qty)

Regards,

Xavier.

• ###### Re: Pareto chart in Qlik Sense

Thanks Xavier - that works perfectly

• ###### Re: Pareto chart in Qlik Sense

Thanks Xavier

It is exactly what I was looking for without succes till to day

Bruno Bertels

• ###### Re: Pareto chart in Qlik Sense

Here is a Waterfall Stacked Barchart with the option of Pareto-like look and feel

http://branch.qlik.com/#!/project/5ab3dc9703e4f8540db95b4d