Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

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

7 Replies
Not applicable

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.

Not applicable

Re: Pareto chart in Qlik Sense

Thanks Xavier - that works perfectly

brunobertels
Valued Contributor II

Re: Pareto chart in Qlik Sense

Thanks Xavier

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

Bruno Bertels

Not applicable

Re: Pareto chart in Qlik Sense

Hi bruno,

Can you share me your qvf of pareto analysis.

Thank you.

Not applicable

Re: Pareto chart in Qlik Sense

Hi,

Here's my test file.

brunobertels
Valued Contributor II

Re: Pareto chart in Qlik Sense

Hi

I post also mine here

Bruno

Employee
Employee

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