topic Re: Combined Axis Required in line chart in QlikView

Combined Axis Required in line chart

Anonymous — Fri, 22 Aug 2014 07:34:52 GMT

Hi,

Need Combined Axis for Line chart,Not hiding of Axis.

I have Dimension Week,And 2 expressions like Actual& Forecast ,for this it is giving 2 Axis one is on Left for Actuals,2 is on Right side for Forecast.Client ios expecting Single Axis ,i tried Hiding one axis but Range in Axis is mismatching.

For the below chart Range is not matching for Actuals and Forecast.Can i combine the Axis for the Both expressions.

Pls share your suggestons and Ideas.

Regard's

Anil Kadiri

Re: Combined Axis Required in line chart

jagan — Fri, 22 Aug 2014 07:58:55 GMT

Hi,

You can use the Single axis for both the expressions based on the values are plotted in the graph by using the single axis.

Regards,

jagan.

Re: Combined Axis Required in line chart

Anonymous — Fri, 22 Aug 2014 08:06:08 GMT

You mean to say is there any option like Single Axis in Line chart?

Re: Combined Axis Required in line chart

Anonymous — Fri, 22 Aug 2014 08:52:34 GMT

Range is Mismatching if i go with Single Axis.If you observe highlighted below screenshot Actual value is 373119,but over the range Axis is crossing 400000.Could you please suggst me the solution fo this.

Re: Combined Axis Required in line chart

jagan — Fri, 22 Aug 2014 09:22:55 GMT

Hi Anil,

I think you didn't changed the axes, try like this

Chart Properties-> Axes-> Expressions

Click on First Expression -> Position -> Select Left (Bottom)

Click on Second Expression -> Position -> Select Left (Bottom)

You need to set the Position to Left for both the expressions.

Hope it helps you.

Regards,

Jagan.

Re: Combined Axis Required in line chart

Anonymous — Fri, 22 Aug 2014 09:26:45 GMT

Thank you