Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

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
Author

Thanks Xavier - that works perfectly

brunobertels
Master
Master

Thanks Xavier

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

Bruno Bertels

Not applicable
Author

Hi bruno,

Can you share me your qvf of pareto analysis.

Thank you.

Not applicable
Author

Hi,

Here's my test file.

brunobertels
Master
Master

Hi

I post also mine here

Bruno

Yianni_Ververis
Employee
Employee

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

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

Rocky6
Creator
Creator

Can you please translate the expression in english. 

 

Thanks