topic Re: Date Format in QlikView

Date Format

Sat, 30 May 2015 09:13:54 GMT

I want to format date in straight table. I want all the date fields in mm/dd format, ie (01/20).

Earlier I had used the following script .. Date (field name, 'MM/DD') but this has to be individually applied to each dimension field, I have 10 date fields in my table and dont want to individually apply to all. How can I do it globally?

Re: Date Format

PrashantSangle — Sat, 30 May 2015 09:17:18 GMT

Hi,

In Script

SET DateFormat='MM/DD';

and then use Date(DateFieldName)

Regards

Re: Date Format

MarcoWedel — Sat, 30 May 2015 11:48:58 GMT

‌did you try the date format definition in the number tab of the chart properties?

regard

Marco

Re: Date Format

fkeuroglian — Sat, 30 May 2015 14:37:46 GMT

Hi, if you want this MM/DD format for all your dates

you can modify the variables that automatic create at the top of the script, see this

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='$U #.##0,00;($U #.##0,00)';

SET TimeFormat='hh:mm:ss TT';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';

good luck

Fernando

Re: Date Format

Anonymous — Sat, 30 May 2015 15:01:33 GMT

Hi Rohan,

In Script Main Page If you Set Date Format='MM/DD' then you can use globally.

Re: Date Format

MarcoWedel — Sat, 30 May 2015 16:53:34 GMT

hope this helps

regards

Marco