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 am importing an excel sheet with 2017 text.
I am trying to convert it to a YEAR in QV and it appears as follows.
Date#(F1, 'YYYY') appears as 2017.00000
Date(F1, 'YYYY') appears as 1905
Year(F1) appears as 1905
Can you try this
Num(F1 * 1)
View solution in original post
May be try this
Year(Date#(F1, 'YYYY')) as Year
Appearing as blank now.
same as above. blank
It seems that your field contained a string with numbers whereby it isn't a date else it's just a year-value. Therefore try something like this:
num(num#(F1, '####.######', '', '.'))