Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview User
I have field called Target which loads values in the following format:
95
85
75
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
If that's always the case you can do as follows in the script:
Field / 100 AS Field
Target / 100 as Target
or
Num(Target/100,'#0.00') as Target
If that's always the case you can do as follows in the script:
Field / 100 AS Field
Load ...,
...,
Num(Target/100,'#.00') as Target
....,
from source