topic Re: Forcing a whole number to be a decimal within script in QlikView

Forcing a whole number to be a decimal within script

helen_pip — Wed, 22 Feb 2017 14:15:53 GMT

Dear Qlikview User

I have field called Target which loads values in the following format:

etc.......

In the script I would like to convert the Target field to be in the following format

0.95

0.85

0.75

Is there a function or format I can use to achieve this

Kind Regards

Helen

MK_QSL — Wed, 22 Feb 2017 14:16:33 GMT

Target / 100 as Target

Num(Target/100,'#0.00') as Target

Miguel_Angel_Baeyens — Wed, 22 Feb 2017 14:17:08 GMT

If that's always the case you can do as follows in the script:

Field / 100 AS Field

Anonymous — Wed, 22 Feb 2017 14:29:22 GMT

Load ...,

...,

Num(Target/100,'#.00') as Target

....,

from source