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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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 !