Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number formatting

can any suggest me how to format numbers

for ex:- i have 45.5643678541315

I just want to round up to 3 decimal after .

like  45.564

I tried this expression =Sum((vAnnualusage), '##.##0')

16 Replies
vardhancse
Specialist III
Specialist III

in properties->Number<Tab>->we can give the desired number format as well

Not applicable
Author

num(45.5643678541315,'#.000')

Not applicable
Author

Pls close the thread

Not applicable
Author

Hi,

properties->Number


Number formatting.png

Not applicable
Author

it's in Text Object sasi. Thanks tho

Not applicable
Author

ceil( 45.5643678541315,0.564)

or

floor(45.5643678541315,0.564)

its_anandrjs
Champion III
Champion III

Hi Syed,

Close the thread by selecting appropriate correct or help full as answer i think there is lot of good responses.

Regards

Anand