topic Re: Complex Chart Help in QlikView

Complex Chart Help

Mon, 04 Mar 2013 12:52:49 GMT

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

Re: Complex Chart Help

lironbaram — Mon, 04 Mar 2013 13:04:32 GMT

hi check the attach file

Re: Complex Chart Help

Mon, 04 Mar 2013 13:05:25 GMT

Check out the attachment

Re: Complex Chart Help

Mon, 04 Mar 2013 14:56:52 GMT

Perfect Thanks!!

Re: Complex Chart Help

Mon, 04 Mar 2013 15:09:06 GMT

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

Re: Complex Chart Help

Tue, 05 Mar 2013 06:31:41 GMT

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

Re: Complex Chart Help

Wed, 06 Mar 2013 16:38:18 GMT

Perfect Many thanks!

Fiorano