Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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

8 Replies
Highlighted
Not applicable

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.

Highlighted
Not applicable

Thanks Xavier - that works perfectly

Highlighted
Specialist II
Specialist II

Thanks Xavier

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

Bruno Bertels

Highlighted
Not applicable

Hi bruno,

Can you share me your qvf of pareto analysis.

Thank you.

Highlighted
Not applicable

Hi,

Here's my test file.

Highlighted
Specialist II
Specialist II

Hi

I post also mine here

Bruno

Highlighted
Employee
Employee

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

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

Highlighted
Contributor II
Contributor II

Can you please translate the expression in english. 

 

Thanks