Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Date Format in Chart (x-axis)

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Date Format in Chart (x-axis)

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

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

7 Replies
mjm
Contributor III

Re: Date Format in Chart (x-axis)

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
Valued Contributor

Re: Date Format in Chart (x-axis)

Hi,

In Dimension you can add:

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

or

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

-Nilesh

MVP
MVP

Re: Date Format in Chart (x-axis)

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

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

Not applicable

Re: Date Format in Chart (x-axis)

thank you so much!

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

Not applicable

Re: Date Format in Chart (x-axis)

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
Valued Contributor

Re: Date Format in Chart (x-axis)

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

Not applicable

Re: Date Format in Chart (x-axis)

Try with Calculated Dimension:

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

Community Browser