topic Re: Date Format in Chart (x-axis) in QlikView

Date Format in Chart (x-axis)

Wed, 18 Dec 2013 15:03:21 GMT

Hi guys,

I gues this question is simple to answer, but I can not figure out how I can display below the x-axis of a chart the date format (DD.MM.YYYY). At the moment it is showing numeric e.g. 41618 but needs to be 10.12.2013. I have tryed in the properties but it does not Change the chart.

Thanks for your help.

Re: Date Format in Chart (x-axis)

mjm — Wed, 18 Dec 2013 15:07:56 GMT

Hello Joachim,

I would suggest using the date() function applied to the variable which you want to use as the x axis. You should apply this date() function within the LOAD script of your qlikview application, as like in the example below:

LOAD

date(varName, MonthFormat) as formattedDate

You can then use formattedDate as a new variable within your charts. MonthFormat is actually taken from the SET statements at the beginning of your QlikView script.

I hope this helps. Please mark as answered if I have helped to answer your question.

Thanks,

Mark

Re: Date Format in Chart (x-axis)

nilesh_gangurde — Wed, 18 Dec 2013 15:09:03 GMT

Hi,

In Dimension you can add:

DATE(DATE_FIELD,'DD.MM.YYYY')

DATE(DATE_FIELD,'DD-MM-YYYY')

-Nilesh

Re: Date Format in Chart (x-axis)

swuehl — Wed, 18 Dec 2013 15:10:07 GMT

What's the format of your dimension field? You can force the date format using a calculated dimension

=Date(DateField, 'DD.MM.YYYY')

Re: Date Format in Chart (x-axis)

Wed, 18 Dec 2013 15:16:22 GMT

thank you so much!

since the chart is created already, how do I access the LOAD script?

Re: Date Format in Chart (x-axis)

Wed, 18 Dec 2013 15:21:19 GMT

I find the Dimension properties, where I can enter field, function, variable, etc. --> where exactly do I have to enter the DATE(DATE_FIELD, 'DD.MM.YYYY')? Am I looking at the right spot?

Re: Date Format in Chart (x-axis)

nilesh_gangurde — Wed, 18 Dec 2013 15:36:00 GMT

Hi,

In Dimension Tab,

Remove your Earlier Dimension which you added.

and then click on the "Add Calculated Dimension"

and Write the following

=DATE(DATE_FIELD,'DD.MM.YYYY')

-Nilesh

Re: Date Format in Chart (x-axis)

Wed, 18 Dec 2013 15:42:23 GMT

Try with Calculated Dimension:

Date(DATE_FEILD, 'DD.MM.YYYY')