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: 
Not applicable

How to limit the decimals in Text Object

HI all

How to limit the decimals in Text Object


i got 43.539290780812 for my calculation

‌I need to show 43.53 in text object

Can any one help me to solve

thanks

AR UMAMAHESH

1 Solution

Accepted Solutions
sunny_talwar

Use the Num() function

=Num(YourExpression, '#,##0.00')

View solution in original post

7 Replies
sunny_talwar

Use the Num() function

=Num(YourExpression, '#,##0.00')

ankit777
Specialist
Specialist

Hi

try this

=num(fieldname,'#.##')

fieldname - it can be an expression too

sunny_talwar

Or this to floor your value

Floor('43.539290780812', 0.01)

avinashelite

try like this

num('43.539290780812','######0.00')

or

num(field_name,'######0.00')

Kushal_Chawda

=floor(YourExpression, 0.01)

Not applicable
Author

Thanks Sunny

It's working

Not applicable
Author

Thank you very much you all


Thanks,

AR UMAMAHESH