Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
MVP & Luminary
MVP & Luminary

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.

View solution in original post

5 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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.

Highlighted
Creator
Creator


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

Highlighted
Creator
Creator


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

Highlighted
MVP & Luminary
MVP & Luminary

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.

View solution in original post

Highlighted
Creator
Creator

Thank you