topic Re: transform the date in QlikView

transform the date

0li5a3a — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

is possible to transform the date format from

42107 TO WW-YYYY?

I don't want to create a master calendar I want to do this just for a specific column in my table.

Thanks

Re: transform the date

prat1507 — Tue, 04 Jul 2017 10:35:52 GMT

Maybe this

=date(42107 ,'WW-YYYY')

Re: transform the date

0li5a3a — Tue, 04 Jul 2017 10:44:03 GMT

I tried already this and doesn't work in my scenario...

the date looks like 01-2017, 02-2017, 03-2017 and again 01-2017, 02-2017, 03-2017 which is wrong suppose to be

01-2017, 02-2017,03-2017, 04-2017 to 52-2017

Re: transform the date

antoniotiman — Tue, 04 Jul 2017 10:44:48 GMT

WeekName(Date) or

Week(Date)&'-'&Year(Date)

Re: transform the date

prat1507 — Tue, 04 Jul 2017 10:49:16 GMT

Sorry

Use

=weekname(date(42094))

Re: transform the date

tyagishaila — Tue, 04 Jul 2017 10:49:40 GMT

=Week(date(42107 ))&'-'&Year(date(42107 ))

Re: transform the date

0li5a3a — Tue, 04 Jul 2017 10:54:06 GMT

using WeekName(Date) i would have this format 2017- 23.

using Week(Date)&'-'&Year(Date) i would have this format 1-2017 ,12016, 2-2017,2-2016 I want to have this format ww-yyyy (52-2016,01-2017,02-2017................20-2017 etc)

Re: transform the date

antoniotiman — Tue, 04 Jul 2017 10:59:04 GMT

Num(Week(Date),'00')