topic How to format decimal fields in script in QlikView

How to format decimal fields in script

cliff_clayman — Tue, 25 Apr 2017 15:07:56 GMT

I have a few decimal fields from a SQL table that I need to format in the script. The user does not want to see the decimals where the value is a round number. For example, currently a value displays as 100.00 and the user wants to see 100. However, if the value is 123.45, then I need it to display as 123.45. Can I handle this in the script or do I do it on the report?

Re: How to format decimal fields in script

Anil_Babu_Samineni — Tue, 25 Apr 2017 16:28:13 GMT

Yes, We can achieve where you want. Would you provide real data to look

Re: How to format decimal fields in script

Peter_Cammaert — Tue, 25 Apr 2017 16:34:40 GMT

Use the same solution as mentioned here: How to format decimals using a format pattern on a report

Re: How to format decimal fields in script

vishsaggi — Tue, 25 Apr 2017 16:38:22 GMT

Hows your SQL decimal field values come through. Are they always two digits after decimal. May be you can try like:

LOAD *,

IF(Subfield(Values, '.',2) = 0, Round(Values), Values) AS FormattedField

FROM yoursource;

Re: How to format decimal fields in script

Digvijay_Singh — Tue, 25 Apr 2017 16:42:41 GMT

You can try Num as suggested above in script as well -

Load ID,Num(Value);

Load * inline [

ID, Value

1, 100.00

2, 100.45

3, 90.00

4, 90.10 ];

Re: How to format decimal fields in script

Digvijay_Singh — Tue, 25 Apr 2017 16:44:05 GMT

Missed to rename value field -

Load ID,Num(Value) as Value;

Load * inline [

ID, Value

1, 100.00

2, 100.45

3, 90.00

4, 90.10 ];