Date Format in Chart (x-axis)

[#1]

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.

JJ

[mjm]

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

[nilesh_gangurde]

Hi,

In Dimension you can add:

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

or

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

-Nilesh

[swuehl · Accepted solution]

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

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

[#5]

thank you so much!

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

[#6]

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?

[nilesh_gangurde]

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

[#8]

Try with Calculated Dimension:

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