Discussion Board for collaboration on QlikView Scripting.
I'm currently working on data where the date is set as week 1 week 2 week 3 (week 1 begining January first). Id like to know if there is a way to transform this data into dates when I load my table?
This is what my loading script looks like atm:
CrossTable(Weeks, Load, 4)
LOAD [People] as [Collab],
Thanks in advance for any help concerning this matter!
Go to Solution.
i don't remember if such a function exists but what you can do is build a date from 01/01/13 (Date1)
using date + Nb
Where Nb is the number of days according to your week n° like
date = $(Date1) + ((WeekNo-1) * 7) + 1
just take the week number 1,2,3...... from week1,week2,week3,..... and multiply with 7 and add with jan 1.
Oh I didnt realise I could manipulate Dates so easily since I'm begining with Click view. Thanks for this answer!
Same answer at almost the same time as christian, thanks both!