Create Pareto Chart for Sales analysis

[#1]

Pareto.qvw

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.

[swuehl]

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

[#3 · Accepted solution]

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

[#4]

Hi Stefan,

I need to split y-axis indeed.

Below an example.

Thanks,

Aldo.

[#5]

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.

[#6]

Hi All,

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

Thanks,

Nihar

[#7]

Nihar,

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

[#8]

Hi Nihar

see the link for add a line on 8020 chart.

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