Discussion Board for collaboration on QlikView Scripting.
I have a xls file that contain a weeknumber e.g. 32 but when I load the data it is presented as 1, 2, 3.... upto 8.
So I assume that I need to convert the week to a weeknumber, what I have done is:
Week(Week of expected work) as WeekExpectedTask,
If I dont use anything it will change the week to a data in 1900.....
So none of the solutions work, what is wrong with this and why?
Thanks in advance,
Go to Solution.
Hi Peter, you can use MakeWeekDate(YearNumber,WeekNumber)
This will return a Date with the start day of the week.
please post a sample application
Thanks this solved my problem