Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: How to limit the decimals in Text Object

Use the Num() function

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

7 Replies

Re: How to limit the decimals in Text Object

Use the Num() function

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

ankit777
Valued Contributor

Re: How to limit the decimals in Text Object

Hi

try this

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

fieldname - it can be an expression too

Re: How to limit the decimals in Text Object

Or this to floor your value

Floor('43.539290780812', 0.01)

Re: How to limit the decimals in Text Object

try like this

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

or

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

Re: How to limit the decimals in Text Object

=floor(YourExpression, 0.01)

Not applicable

Re: How to limit the decimals in Text Object

Thanks Sunny

It's working

Not applicable

Re: How to limit the decimals in Text Object

Thank you very much you all


Thanks,

AR UMAMAHESH

Community Browser