topic Re: Date transformation in QlikView

Date transformation

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

hi all

i have a field with this form 6/1/2016 (jun 1-2016) i need to transform it to a number as 42522

hope u can help thanks

‌

MindaugasBacius — Fri, 01 Jul 2016 06:23:27 GMT

LOAD Value
     ,date#(Value, 'DD/MM/YYYY') as Date
     ,num(date#(Value, 'DD/MM/YYYY')) as Date_num
INLINE [
    Value
    6/1/2016
];

Result:

migueldelval — Fri, 01 Jul 2016 06:23:32 GMT

Hi Mario,

Try with this expression: =Num#(6/1/2016, '##,##')

Regards

Miguel del Valle

MK_QSL — Fri, 01 Jul 2016 06:27:14 GMT

Set below in your script..

SET DateFormat='M/D/YYYY';

Now use

Num(YourDateField) as DateFieldinNum

in script.

=Num(YourDateField) in text box or chart

tamilarasu — Fri, 01 Jul 2016 06:32:14 GMT

You can try in either load script or expression like below,

Num(Date#(DateField,'M/D/YYYY'))

Chanty4u — Fri, 01 Jul 2016 06:45:40 GMT

try this

Num(Date#(DateField,'M/D/YYYY'),'M/D/YYYY') AS newdate

susovan — Fri, 01 Jul 2016 09:04:19 GMT

You can also try this,

Month:

LOAD * INLINE [

Month_Date

6/1/2016

];

LOAD *,

Num(Month_Date) as @_Month_Date Resident Month

vcanale — Fri, 01 Jul 2016 09:14:21 GMT

Hi,
try
=NUM(Date#(FieldName,'M/D/YYYY'), ##,##0)