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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Format Text Box

Hi

I have a text box which displays a value on megabytes, the data ranged between 2-12 digits , i dont want the data to display after the decimal point , how do i format this , for eg: the values is 12,349.23456, i just want 12,349

Please Help

4 Replies
Not applicable
Author

Use the num() function, have a look in help to see how to format this

Anonymous
Not applicable
Author

The simpliest way is to use floor() function. Just keep in mind that is not the same as rounding.

Anonymous
Not applicable
Author

thank you !

Anonymous
Not applicable
Author

thank you !