Recipe for a Pareto Analysis

[#1]

Hi All

I try to duplicate the HIC post on the above mentioned :-

http://community.qlik.com/blogs/qlikviewdesignblog

I am not able :-

1. Make the chart Bar show yellow color when it is less then 80%

2. How to plot a blue line at 80%.

3. How to sort the sales column.

Enclosed my QV doc

[#2]

Hi HIC

I have post the QV doc and i have confirm that other user using ver 11 to open my QV doc , they see the bar chart diff from what i see.

http://community.qlik.com/thread/101928

Any idea ?

Paul

[#3]

Hi HIC

I manage to found the issue on 8020 chart view on my note book different from your and tres note book.

The issue is cause by ver 9 SR3 i am using. which cause the problem. After i have upgrade to SR7 now it work fine.

Thank you.

Paul

[#4]

Hi HIC

you mentioned the below :-

What I mean with "calculating on the fly" is to be able to calculate the Pareto Class as a Calculated Dimension or as a Calculated Field in a List Box. I do not think this is possible.

I don't understand what you mean.  8020 cannot cal on the fly ?

in order for me to understand it , i like to ask  you open my QV doc. when you click on the either button , it does cal 8020.

So from the QV doc it does able to cal on the fly.

Hope you can share with me .

Paul

[hic]

Your pareto chart will of course calculate no matter which selection you make. Which is excellent and exactly what you want.

But what I meant with "on the fly" is to make the same pareto calculation but without this chart. To put the same logic in a formula that you can use as Calculated Field in a list box or as Calculated Dimension. I have not found a way to do this with today's set of functions.

HIC