Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
btrompetter
Contributor III
Contributor III

Format Numeric Values

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

1 Solution

Accepted Solutions
Not applicable

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

5 Replies
Not applicable

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
Partner - Specialist
Partner - Specialist

Hi

U can use this also

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

prieper
Master II
Master II

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

Not applicable

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