Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sreelathamohan
Contributor
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?

34 Replies
sunny_talwar

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

sreelathamohan
Contributor
Contributor
Author

Cumulative % Expression:

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

Failure Detail is the dimension name

 

sunny_talwar

Try this

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

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

sunny_talwar

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

sreelathamohan
Contributor
Contributor
Author

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

sunny_talwar

Sure thing.

sreelathamohan
Contributor
Contributor
Author

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

sreelathamohan
Contributor
Contributor
Author

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