This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i have a field [QVDYEARWEEK] which has value in number which has year and week attach , how to break this into year and week
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;
View solution in original post
or directly in the same load like this -
Num(Left(QVDYEARWEEK,4)) as Year,
Num(Right(QVDYEARWEEK,2)) as Weekno