Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to create a pareto chart from both x and y dimension

Hi Friends

I have a simple table with simple calculation. i did not use function to do running sum and get the percentages of total. just use the default accum, relative option in building a chart.

basically, we have contract, and customer using contract to open cases. i use the contract as dimension, sorted by descending of how many cases are opened on that contract.

check the Full Accumulation and Relative, got the table i needed, see the detail setting below

Capture.PNG

the table i got look like this:

Capture.PNG

you can see 19% of contract created 75% cases. like common 20-80 scenario!

now my question is how can i turn the number in the Case Count Accum and Contract Accum into a line chart like a pareto chart...

Best Regards,

1 Reply
el_aprendiz111
Valued Contributor

Re: How to create a pareto chart from both x and y dimension

Community Browser