How do I change the format of the date x-axis in a line chart?

[#1]

My date format is displayed as MMMYY in my tables in data manager. But when I use this date field as my dimension in a line chart the date appears as dd.mm.yy.00:00:00 on the x-axis. How do I change this format as I can't find the option in properties.

[ahaahaaha]

Привет Laurelly,

К сожалению, я не мог воспроизвести вашу ситуацию (см прикрепленный файл). Вы можете разделить файл QVF с фрагментом данных?

С Уважением,

Андрей

[migueldelval]

Hi Laurelly,

You have two options:

a) Use in your chart: date(DATE_FIELD,'DD/MM/YYYY')

b) If you don´t want to show never hours/minutes/seconds. In you script use

date(DATE_FIELD, 'DDMMYYYY') as DATE_FIELD

Date ‒ QlikView

Regards

Miguel del Valle

[OmarBenSalem]

In the line chart, under aspect, under x-axis, uncheck the "continue" axis:

[viveksingh]

Try This,

DATE(TIMESTAMP(DATE_FIELD),'MMM-YY')

[sigmadelta]

No this doesn't work for me (a complete newbie).

When I try your suggestion, I get the following, i.e. the label changes, but the dates are still in numeric (days since 1900) format, even though the incoming data is seen in the Data tables as YYYY-MM-DD hh:mm:ss