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

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

Number formate

Hi..

my number is 0.0008945 i want to to display only 0.006 formate means after point i want to display only 3 digits.

please help me..

Regards,

Chandini.g

3 Replies
senpradip007
Specialist III
Specialist III

Try like:

Num([Your Number], '#.###')

or

round([Your Number], 0.001)

alexandros17
Partner - Champion III
Partner - Champion III

use

ceil(0.0008945, 0.0001)

Anonymous
Not applicable
Author

Hi..

Thanks for reply...

Regards,

Chandini