Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

tincholiver
Contributor II

Date format in a chart

Hello everyone, does anyone know where I can set the date field on a graph?
I have two app with the same data, same script however in one case it brings me the dates in one format while in the other it does not.
I can not find how to make the date DD / MM / YYYY format, and probe editing the field from the dimension but it did not work.

Thanks in advance

Date Format.png

2 Solutions

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Date format in a chart

In the chart properties go to Number tab and select this date dimension and check radio button Date and add format DD/MM/YYYY.
Or in the script just add like

Date(Yourdatefield, 'DD/MM/YYYY')
tincholiver
Contributor II

Re: Date format in a chart

the date is already formatted from the script and the dimension does not show it in the configuration of the number tab. I tried doing it from the edition of the dimension, date (DATE, 'DD / MM / YYYY'), the drawback was that the graphic has a continuous axis and that made the date appear in numerical format.
you have to mark continuous axis and date format.
thanks vishaggi!

Date Format 2.png

3 Replies
vishsaggi
Esteemed Contributor III

Re: Date format in a chart

In the chart properties go to Number tab and select this date dimension and check radio button Date and add format DD/MM/YYYY.
Or in the script just add like

Date(Yourdatefield, 'DD/MM/YYYY')
tincholiver
Contributor II

Re: Date format in a chart

the date is already formatted from the script and the dimension does not show it in the configuration of the number tab. I tried doing it from the edition of the dimension, date (DATE, 'DD / MM / YYYY'), the drawback was that the graphic has a continuous axis and that made the date appear in numerical format.
you have to mark continuous axis and date format.
thanks vishaggi!

Date Format 2.png

andrescc
New Contributor III

Re: Date format in a chart

Hi,

Use a Calculated Dimension: Date(your_field), just this, without format

Regards,
ACC