Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

transform the date

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

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

Re: transform the date

WeekName(Date) or

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

View solution in original post

7 Replies
Highlighted
Specialist
Specialist

Re: transform the date

Maybe this

=date(42107 ,'WW-YYYY')

Highlighted
Creator III
Creator III

Re: transform the date

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

Highlighted
Master III
Master III

Re: transform the date

WeekName(Date) or

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

View solution in original post

Highlighted
Specialist
Specialist

Re: transform the date

Sorry

Use

=weekname(date(42094))

Highlighted
Specialist
Specialist

Re: transform the date

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

Highlighted
Creator III
Creator III

Re: transform the date

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)

Highlighted
Master III
Master III

Re: transform the date

Num(Week(Date),'00')