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: 
arjakumar
Contributor III
Contributor III

How to change the value 12.3456 to 12.34 using string function

How to change the value 12.3456 to 12.34 using string function

4 Replies
devarasu07
Master II
Master II

Hi,

using string fxn? if so just use the left fxn =left(12.3456,5)

better way is the number fxn like below

=Num(12.3456,'##.00')

i.e update your field name instead of the hard coded value

Anil_Babu_Samineni

Num(Value,'##.00')

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
jonathandienst
Partner - Champion III
Partner - Champion III

Do you want to round the number (ie to 12.35) or round it down (to 12.34)?

Round up:  Ceil(12.3456, 0.01)

Round:  Round(12.3456, 0.01)

Round down:  Floor(12.3456, 0.01)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
arjakumar
Contributor III
Contributor III
Author

I also want to change 12.3456 to 12.35 when 3rd postion after decimal point is >=5.