Format Numeric Values

[btrompetter]

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

[#2 · Accepted solution]

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 ######.

[rwunderlich]

In Document Properties -> Number change the value for this field to Integer.

-Rob

[sathishkumar_go]

Hi

U can use this also

num(fieldname,'######')

[prieper]

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

[#6]

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