topic Re: Date format in a chart in QlikView

Date format in a chart

tincholiver — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Date format in a chart

vishsaggi — Wed, 20 Feb 2019 20:46:47 GMT

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')

Re: Date format in a chart

tincholiver — Wed, 20 Feb 2019 21:55:46 GMT

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!

Re: Date format in a chart

andrescc — Thu, 21 Feb 2019 04:23:04 GMT

Hi,

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

Regards,
ACC