topic Re: Create Pareto Chart for Sales analysis in QlikView

Create Pareto Chart for Sales analysis

Tue, 19 Jul 2011 13:46:06 GMT

Hi Guys,

Need help to creat pareto chart for sales analysis.

Please see the qvw attached. I am trying to split the axes in order to show sales amount in left side, and accumulative percent in right side.

What's missing?

Thanks in advance,

Aldo.

Create Pareto Chart for Sales analysis

swuehl — Tue, 19 Jul 2011 14:03:03 GMT

Hi Aldo,

According to the help, I think spilt axis affects the y-axis and not the x-axis.

I got a split, but that's probably not what you want.

What do you want to show in detail?

Stefan

Re: Create Pareto Chart for Sales analysis

Tue, 19 Jul 2011 14:31:09 GMT

Hi Aldo,

Not sure i understood your question properly.

I have changed the "Position" of the 2nd expression "Accumulated sales" to "Right" in Presentation tab which you`ll find in position frame.

Look at the attached application.

Hope this helps you.

- Sridhar

Re: Create Pareto Chart for Sales analysis

Tue, 19 Jul 2011 18:45:03 GMT

Hi Stefan,

I need to split y-axis indeed.

Below an example.

Thanks,

Aldo.

Re: Create Pareto Chart for Sales analysis

Tue, 19 Jul 2011 18:49:04 GMT

Hi Sridhar,

That's exacly what I was looking for.

I noted you didn't used split axes, and instead just set first expression to left side, second to right one... that's a bit confusing because I thought I need to split the axis (it sounds logical...)

Thanks,

Aldo.

Re: Create Pareto Chart for Sales analysis

Fri, 12 Apr 2013 10:35:15 GMT

Hi All,

Is there a way to draw a straight line at 80% in the given chart?

Thanks,

Nihar

Re: Create Pareto Chart for Sales analysis

Mon, 09 Dec 2013 19:28:07 GMT

Nihar,

Here is a pretty basic example: http://www.quickqlearqool.nl/?p=1086

Re: Create Pareto Chart for Sales analysis

Wed, 11 Dec 2013 02:26:13 GMT

Hi Nihar

see the link for add a line on 8020 chart.

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