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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Round thousants

Hi,

Small question, quick answer. I need a rounding of an expression in the chart number setting.

If the number is 10.113.106,  the rounding should be 10.113. What's the proper number format setting?

Regards,

Robert

Labels (1)
1 Solution

Accepted Solutions
Not applicable
Author

Go to Properties of the Object -> Number -> Select the particular filed -> Select the Number Format Settings as "Fixed to" -> Fix the Decimal to 3. Only 3 digit decimal will be displayed.

View solution in original post

3 Replies
sunny_talwar
MVP
MVP

May be like this:

Round(Number/1000)

Not applicable
Author

Go to Properties of the Object -> Number -> Select the particular filed -> Select the Number Format Settings as "Fixed to" -> Fix the Decimal to 3. Only 3 digit decimal will be displayed.

Anonymous
Not applicable
Author

Hi Vinu,

Thanks but's not a decimal, it's a thousands cut off...