Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Not applicable

Pareto chart in qlik sense

Hi all,

How to build a pareto chart in qlik sense?  can help me with step by step process.

regards

Prashanth

5 Replies
gautik92
Valued Contributor III

Re: Pareto chart in qlik sense

Have a look at this blog

Recipe for a Pareto Analysis

Not applicable

Re: Pareto chart in qlik sense

Hi gowtham,

the link you referred is for qlik view. i want to do it in qlik sense.

Regards

Prashanth

Not applicable

Re: Pareto chart in qlik sense

Hi,

go through this it might help u,

Pareto chart in Qlik Sense

Not applicable

Re: Pareto chart in qlik sense

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

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

Community Browser