Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
anilnaidu13
Contributor

Combined Axis Required in line chart


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.

Combined Axes.png

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

range.png

Pls share your suggestons and Ideas.

Regard's

Anil Kadiri

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Combined Axis Required in line chart

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.

5 Replies
MVP & Luminary
MVP & Luminary

Re: Combined Axis Required in line chart

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.

anilnaidu13
Contributor

Re: Combined Axis Required in line chart


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

anilnaidu13
Contributor

Re: Combined Axis Required in line chart


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.

RangeMismatch.png

MVP & Luminary
MVP & Luminary

Re: Combined Axis Required in line chart

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.

anilnaidu13
Contributor

Re: Combined Axis Required in line chart

Thank you