Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thanks Xavier - that works perfectly
Thanks Xavier
It is exactly what I was looking for without succes till to day
Bruno Bertels
Hi bruno,
Can you share me your qvf of pareto analysis.
Thank you.
Hi,
Here's my test file.
Hi
I post also mine here
Bruno
Here is a Waterfall Stacked Barchart with the option of Pareto-like look and feel
Can you please translate the expression in english.
Thanks