Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
sreelathamohan
New Contributor

Pareto Chart

I have a pareto chart in my application (see attached). Some of the dimension values are Null. When I suppress NUll values I don't see the 100% on the Cumulative Line chart. But I show Null values then I can see the cumulative % values until 100%. How do I show 20 - 100% all values and not count Null dimension values for the chart?

32 Replies
Highlighted

Re: Pareto Chart

What is your expression for Cumulative %? and what is your dimension name in the chart?

Highlighted
sreelathamohan
New Contributor

Re: Pareto Chart

Cumulative % Expression:

RangeSum(Above(Sum([Quantity Affected]), 0, RowNo())) / Sum(total [Quantity Affected])

Failure Detail is the dimension name

 

Highlighted

Re: Pareto Chart

Try this

RangeSum(Above(Sum([Quantity Affected]), 0, RowNo())) / Sum(TOTAL {<[Failure Detail] *= {"*"}>}[Quantity Affected])
Highlighted
sreelathamohan
New Contributor

Re: Pareto Chart

Not working. That shoots up the total % to more than 100 and I still see the Null dimension values

Highlighted

Re: Pareto Chart

Suppress the null dimension now...sorry, I should have told that....

Highlighted
sreelathamohan
New Contributor

Re: Pareto Chart

That worked Sunny. Thank you very much !! I might have another question for you soon.

Highlighted

Re: Pareto Chart

Sure thing.

Highlighted
sreelathamohan
New Contributor

Re: Pareto Chart

Sunny - One small issue - the total cumulative % against the last bar shows 100.85%. Why would that be?

Highlighted
sreelathamohan
New Contributor

Re: Pareto Chart

Also some of the bars don't show any value when in fact there are values. Please take a look at the screenshot