topic Format Numeric Values in QlikView

Format Numeric Values

btrompetter — Wed, 29 Apr 2009 22:15:42 GMT

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

Format Numeric Values

Wed, 29 Apr 2009 23:09:57 GMT

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

Format Numeric Values

rwunderlich — Wed, 29 Apr 2009 23:10:16 GMT

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

-Rob

Format Numeric Values

sathishkumar_go — Wed, 29 Apr 2009 23:20:01 GMT

U can use this also

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

Format Numeric Values

prieper — Thu, 30 Apr 2009 04:14:33 GMT

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

Format Numeric Values

Thu, 30 Apr 2009 15:40:23 GMT

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