Discussion Board for collaboration on QlikView Scripting.
i have a field [QVDYEARWEEK] which has value in number which has year and week attach , how to break this into year and week
Go to Solution.
I don't know if TABLE1 is a field name or the table you are loading, so assuming it is the table name, try using a preload statement:
Mid(QVDYEARWEEK,1,4) as YR,
Mid(QVDYEARWEEK,5,2) as WK;
or directly in the same load like this -
Num(Left(QVDYEARWEEK,4)) as Year,
Num(Right(QVDYEARWEEK,2)) as Weekno