Data pulled in wrong format - Oracle Varchar field

[#1]

Hi All,

I have a field in the varchar data type in Oracle and Qlikview reloads it in a mixed format. The field value is '5.2' in the database and Qlikview shows it '5.20'. I can't change the number setting to a fixed decimal as it will screw up the other values. I want it to display 5.2 as it is in the datbase. I've tried the text() function and it didn't work. Any ideas on how it can get fixed?

Thanks a lot.

[#2]

Hi,

You need to apply a format with num() function.

Ej. num(FieldNumber, '0.0'), You should type a zero each N decimal.

I hope to be will helpful.

Regards,

Ricardo

[#3]

Hi Ricardo,

thanks for your reply. If I use the num function it will affect all the other numbers in format 5.232, 5.21 , 5.1290 etc. I can't force a decimal value to this field for the reason. Is there a way I can show the records as they are in the database? I mean its a varchar field, I have no problem displaying it in varchar or text format. I just want the exact representation of the data as it is in the database.

thanks again.

[#4]

replace(trim(replace(field_name,'0',' ')),' ','0')

Will this work?

--

Regards,

Kiran Rokkam.