Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
replace(trim(replace(field_name,'0',' ')),' ','0')
Will this work?
--
Regards,
Kiran Rokkam.