Complex Chart Help

[#1]

Hi,

I need to recreate an Excel chart within Qlikview.  This is the excel chart

The above chart is showing :

• The sum of Total Finishers (blue stack)
• The sum of those that Did Not Finish (red stack)
• Target Rate (Green Line)
• Actual Did Not Finish Rate (Purple Line)

Also, can the Number Axes be shown on the right and the rate Axes be shown on the left.

Ive attached a sample attempt, but cant get the rate to show and target to show correctly (due to the size of the left axes).

Can anyone help?

Many Thanks,

Fiorano

[lironbaram · Accepted solution]

hi check the attach file

[#3]

Check out the attachment

[#4]

Perfect Thanks!!

[#5]

I hope you dont mind my asking.  I'm trying to set up a Gauge Chart using the same data by Year.  Do you have any experience of these charts?  I will need a Red, Amber, Green format to it. With Red being less than 90% of the Target field, Amber 90-99% of the target and green >99% of Target.

Really appreciate your help.

Fiorano

[#6]

Hie see the doc have created the gauge chart for RATE.

[#7]

Perfect Many thanks!

Fiorano