Discussion board where members can get started with QlikView.
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.
View solution in original post
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
=Week(date(42107 ))&'-'&Year(date(42107 ))
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)