topic Re: Date Format in QlikView

Date Format

Srinivas — Wed, 16 Apr 2014 04:12:26 GMT

Hi All,

My date format is few of 'Text format'and few of 'Number format' .

Like : 2014-03-01

2014-03-01

2011-07-01... Etc this are text formate...

40728

40729

40730

40731

40732... Etc this are Number format....

Could you help on this..

Advance Thanks

Munna

Re: Date Format

Wed, 16 Apr 2014 04:18:09 GMT

Check this in a text object by selecting any one value randomly

=Date(Date#(DateField,'YYY-DD-MM'),'DD/MM/YYYY')

If it works, then use as is in the load script by changing with your DateField.

Re: Date Format

Wed, 16 Apr 2014 04:23:06 GMT

Upadte :

Use this will work as you expected.

=alt(date#( DateField ,'YYYY/MM/DD' ),
date(DateField,'DD/MM/YYYY'))

Re: Date Format

MayilVahanan — Wed, 16 Apr 2014 04:45:27 GMT

Try like this

In script,

Alt(Date(Date#(DateField,'YYYY-MM-DD'),'DD/MM/YYYY') , Date(DateField,'DD/MM/YYYY')) AS DateField

Hope that helps

Re: Date Format

jagan — Wed, 16 Apr 2014 05:25:24 GMT

Hi,

Try like this in load script

Data:

LOAD

Alt(Date(Date#(DateDimensionName,'YYYY-MM-DD')) , Date(DateDimensionName)) AS DateField

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Date Format

er_mohit — Wed, 16 Apr 2014 05:39:54 GMT

See the attached file

Date(num(alt(DAtefield)),'YYYY-MM-DD') as Date

Re: Date Format

maxgro — Wed, 16 Apr 2014 06:00:12 GMT

as already suggested use alt function when you have different format in the same field

you can find a detailed explanation at pag 8 of this doc

QlikView Date fields

Re: Date Format

MK_QSL — Wed, 16 Apr 2014 06:05:23 GMT

Load

DATE(Alt(Date#(DATE,'YYYY-MM-DD'),

DATE)) as DATE Inline

[

DATE

2014-03-01

2011-07-01

40728

40729

40730

40731

40732

];