Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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?
regards
Bastian
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 ######.
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 ######.
In Document Properties -> Number change the value for this field to Integer.
-Rob
Hi
U can use this also
num(fieldname,'######')
Hi,
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
/Martin