Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Create Pareto Chart for Sales analysis

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.

1 Solution

Accepted Solutions
Not applicable

Re: Create Pareto Chart for Sales analysis

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

7 Replies
MVP
MVP

Create Pareto Chart for Sales analysis

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

Not applicable

Re: Create Pareto Chart for Sales analysis

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

Highlighted
Not applicable

Re: Create Pareto Chart for Sales analysis

Hi Stefan,

I need to split y-axis indeed.

Below an example.

Thanks,

Aldo.

Pareto Sample.jpg

Not applicable

Re: Create Pareto Chart for Sales analysis

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.

Not applicable

Re: Create Pareto Chart for Sales analysis

Hi All,

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

Thanks,

Nihar

Not applicable

Re: Create Pareto Chart for Sales analysis

Nihar,

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

Not applicable

Re: Create Pareto Chart for Sales analysis

Hi Nihar

see the link for add a line on 8020 chart.

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