Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

Forcing a whole number to be a decimal within script

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

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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

Field / 100 AS Field

View solution in original post

3 Replies
MK_QSL
MVP
MVP

Target / 100 as Target

or

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

Miguel_Angel_Baeyens

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

Field / 100 AS Field

Anonymous
Not applicable

Load ...,

...,

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

....,

from source