Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How to build a pareto chart in qlik sense? can help me with step by step process.
regards
Prashanth
Have a look at this blog
Hi gowtham,
the link you referred is for qlik view. i want to do it in qlik sense.
Regards
Prashanth
hi harshitha,
I found the link u just shared .
[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
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)- how to do sorting?]
Facing problem with highlighted lines.
Regards
Prashanth
Here is a Waterfall Stacked Barchart with the option of Pareto-like look and feel