Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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')

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

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.