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 one YEARWEEK Dimension.which is in Oracle a number field and looks like 200903
In QlikView it looks like 200903,00
How can I change it to the correct format?
Is this in an expression? On a chart, you can go to the Number tab and select Number. Then in the Format Pattern box, use ######.
View solution in original post
In Document Properties -> Number change the value for this field to Integer.
U can use this also
guess that you would like to see a date in January, which corresponds to week 3 in 2009? Am not aware that there is a function existing, but might be constructed manually, but have no code ready on hand for this
Another way could be converting the number into textformat. text(YearWeek)
If you want it to handle as a date of the week you can use the function makeweekdate:
makeweekdate(left(YearWeek,4),right(YearWeek,2),0) as t_Date