Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
jagan
Luminary Alumni
Luminary Alumni

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
jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author


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

Anonymous
Not applicable
Author


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

jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author

Thank you