topic Conversion field format in QlikView

Conversion field format

QSense — Wed, 07 Nov 2012 08:28:45 GMT

Hello everyone,

In order to use in qw ,

I must convert number field into date format

I get data from oracle db number format is : YYYYWW and also date format should be YYYYWW

to_date(to_char(ORIGIN_YEAR_WEEK),'YYYYWW') sql auery does not work

Best regards

sujeetsingh — Wed, 07 Nov 2012 09:08:55 GMT

Hi,

Just use function

-Dtae#(date_field)

or you can also try

-Date(date_field)

QSense — Wed, 07 Nov 2012 09:25:24 GMT

Ii did not work

swuehl — Wed, 07 Nov 2012 09:33:17 GMT

Try

MakeWeekDate(YYYY [ , WW [ , D ] ] )

function, like

Makeweekdate(left(ORIGIN_YEAR_WEEK,4),right(ORIGIN_YEAR_WEEK,2) )

in your LOAD or an expression.

Hope this helps,

Stefan

QSense — Wed, 07 Nov 2012 10:17:17 GMT

ORIGIN_YEAR_WEEK column' s data are like this 201201,201202

swuehl it didnt work in expression I will try in load statement

swuehl — Wed, 07 Nov 2012 10:28:39 GMT

=MakeWeekDate(left(201202,4),right(201202,2))

returns 09/01/2012 when used as expression in a textbox, seems ok to me.