topic Date format in Dimension field in QlikView

Date format in Dimension field

Tue, 24 May 2011 09:10:49 GMT

Hi All,

I am importing a table from MS Access including a date field. In Access I see the date as dd/mm/yyyy

When I import it to QV I see the date as a serial number, eg 40210, 40247 etc.

That's not a major problem - I have created a list box to display all dates and just set the number format as Date - dd/mm/yyyy

However, I want to plot a chart using the date as my x-axis. So I have selected Date as a dimension, but it displays as a serial number on the chart. How do I get this to show in dd/mm/yyyy format?

Thanks for any suggestions,

Tony

Re: Date format in Dimension field

Tue, 24 May 2011 09:13:26 GMT

Hi,

In script change to

date(Datefield,'DD.MM.YYYY') as DateField

Regards

Sravan

Date format in Dimension field

Tue, 24 May 2011 09:17:59 GMT

Hi,

You have to easy options. The first one is to use a Calculated Dimmension instead of the field with the date itself. For example, if the field with the date is A, use as dimmension Date(A).

The second option is to apply this change in the script instead of using on the chart when loading the data. The advantage of this solution is that you will not have to "translate" the date anymore in any other charts

Date format in Dimension field

Tue, 24 May 2011 09:18:48 GMT

Perfect, thanks Sravan.