Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
anilnaidu13
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
jagan
MVP
MVP

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
MVP
MVP

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
Creator
Creator
Author


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

anilnaidu13
Creator
Creator
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
MVP
MVP

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

anilnaidu13
Creator
Creator
Author

Thank you