topic Re: Re: Re: Recipe for a Pareto Analysis in QlikView

Recipe for a Pareto Analysis

Tue, 10 Dec 2013 09:05:12 GMT

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

Re: Recipe for a Pareto Analysis

hic — Tue, 10 Dec 2013 09:16:58 GMT

You had missed to sort the bars by expression.

HIC

Re: Recipe for a Pareto Analysis

Tue, 10 Dec 2013 10:28:23 GMT

Hi HIC

Thank you for your reply to my post. i must said all your blog post very are very interesting , and i like this one , because you make the chart display all the impt info.

The QV doc you send me is not sort as per your upload image , can you kindly help me to send the correct qv doc again pls. as i still unable to sort the bar chart. now bar chart look like below:-

Paul

Re: Recipe for a Pareto Analysis

hic — Tue, 10 Dec 2013 10:46:52 GMT

The changes I did to your document were:

Set the sort order - Sort by expression. (picture shows status after change)

Turn off the accumulation of "Inclusive Percentage" and turn off "Relative". (picture shows status before change)

Enable the Exclusive percentage (picture shows status before change)

HIC

Re: Recipe for a Pareto Analysis

Tue, 10 Dec 2013 12:24:46 GMT

HIC

clever help me , found the bug of using row for accumulated sales , no wonder i keep trying and not able to get what i want. i will try to avoid

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

Re: Recipe for a Pareto Analysis

Tue, 10 Dec 2013 22:37:32 GMT

Hi HIC

I have try your pointer with 3 image, i still not able to get it right.

From you first reply , the image you post show the chart working fine , it is possible for you to send me the QV doc which is working. ( Previously the one you send is not working ).

Paul

Re: Re: Recipe for a Pareto Analysis

hic — Wed, 11 Dec 2013 08:23:51 GMT

Here you are. /HIC

Re: Re: Re: Recipe for a Pareto Analysis

Wed, 11 Dec 2013 08:55:41 GMT

Thank HIC

This is the same one which you send last time. Funny below image is what i see when i open your QV doc send to me , are you seeing the same image ? if yes , may i know why you post one image during your first reply , you image the sales bar is sort from hi to lo. where mine is not.

Paul

Re: Re: Re: Re: Recipe for a Pareto Analysis

Thu, 12 Dec 2013 22:54:19 GMT

Hi HIC

I am very sorry to keep asking you again.

As I am still confuse. Hope you can enlighten me on this . when you first reply me my post , you post a image below , which is what i am looking for. But then when you give me the QV doc i keep getting sales bar is not sort in hi to lo. and you told me i miss out sort in expression sum(sales).

I told you after add sum(sales) , i still not able make the chart as below , again you give me 3 screen shot , and i try still unable to make it .

So i just like to know it is due to QV ver i am using 9 and you are using ver 11 , and the buy for ver 11 is already clear on when using row to cal the sales contribution ? But then i the blog post you make a comment , sales contribution cal on the fly is not possible for dynamic diamension. Hope you can clear my doubt. Any many thank for your contribution in many nice article.

Re: Recipe for a Pareto Analysis

hic — Fri, 13 Dec 2013 08:32:14 GMT

I don't know why you don't see the same graph. When I download the "QV_Template ver079 hic.qvw" above (from this thread) and open it in QlikView 9, the graph looks perfect:

So I do not believe it has to do with the version.

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.

HIC

Re: Recipe for a Pareto Analysis

Mon, 16 Dec 2013 07:37:00 GMT

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

Re: Recipe for a Pareto Analysis

Wed, 18 Dec 2013 04:56:51 GMT

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

Re: Re: Recipe for a Pareto Analysis

Wed, 18 Dec 2013 06:08:15 GMT

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

Re: Recipe for a Pareto Analysis

hic — Wed, 18 Dec 2013 07:26:32 GMT

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