topic Date Formats - help wanted in QlikView

Date Formats - help wanted

Wed, 09 Apr 2014 13:10:55 GMT

I have dates that are being displayed as numbers but can't find a way to format them as dates (see attached). The only place I know to do this formatting is in Properties/Number. But the date is not listed as a posible selection to format. The Date only shows up in the Dimension and Presentation tabs and I can't find a way to format it as a date in either of those tabs. Any suggestions?

Re: Date Formats - help wanted

Wed, 09 Apr 2014 13:14:11 GMT

Hi Denise,

If you edit the dimension (or create a Calculated Dimension), you can use:

=Date([Gas Day],'DD/MM/YYYY')

Or you may have to convert to date format:

=Date#([Gas Day],'DD/MM/YYYY')

Hope this helps!

Re: Date Formats - help wanted

Wed, 09 Apr 2014 13:23:05 GMT

date(41738) will give you 4/9/2014

In you script do

date(datefield, 'MM-DD-YYYY') as datefield,

Re: Date Formats - help wanted

Anonymous — Wed, 09 Apr 2014 13:24:01 GMT

You can format it in the document settings under number

or you format it using the date function date(yourdate)

Re: Date Formats - help wanted

Greg_Hood — Wed, 09 Apr 2014 13:28:42 GMT

Hi Denise, it looks like the gas day field is being imported purely as a number. The best way to solve this would be in your load script, essentially tell QlikView that you want this field to be a date, not purely a number. You can do that by using the date() function in the script. QlikView tries to interpret values or fields when it loads them, but sometimes it is safer to specify what you want.

LOAD * ,

date(OldDate) as DateNoHash;

load * Inline [

OldDate

41738

41739

41740

41741];

See the attached simple example which may help you. Thanks for choosing QlikView!

Re: Date Formats - help wanted

cfz — Wed, 09 Apr 2014 13:31:13 GMT

Hi Denise,

You can for instance use the date functions in the script and transform the values before saving them or or you can use them when creating a calculated dimension already in the chart

In this post the date functions are explained in detail

http://community.qlik.com/message/411955#411955

I hope it helps you.

Kind regards

Carlos

Re: Date Formats - help wanted

Wed, 09 Apr 2014 13:39:25 GMT

thank you very much