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

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

jblomqvist — Mon, 29 Jan 2018 13:56:36 GMT

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.

sunny_talwar — Mon, 29 Jan 2018 14:00:31 GMT

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

jblomqvist — Mon, 29 Jan 2018 14:07:42 GMT

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