Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

Line chart problem: Using Continous option in Axes tab turns my MonthYear values into numeric values?

Hello,

I am having a problem with my line chart:

Dimension: MonthYear (values are Jan 2017, Feb 2017 etc)

Measure: Count(Orders)

The line chart works perfectly when it is like this.

However

When I go to Axes tab and tick Continous it turns the labels into numeric values.

How can I ensure while Continious is ticked it shows the actual MonthYear labels as original (e.g. Jan 2017, Feb 2017 etc)?

I tried Date(Date, 'MMM') & ' ' & Year(Date) but it does not work as Continous option means it expects numeric values.

We are using v12.0 of QlikView.

1 Solution

Accepted Solutions
sunny_talwar

After setting the continuous axis, go to the number's tab and set your continuous X-axis's format from there

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

After setting the continuous axis, go to the number's tab and set your continuous X-axis's format from there

Capture.PNG

jblomqvist
Specialist
Specialist
Author

Sunny, it's great you are here to help. Problem solved. Thank you!