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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
noman212
Creator III
Creator III
‎2016-01-07 05:51 AM

Round Off

Dear All,

I have a no two nos.

2147 and 2933

I want to round of 2147 to 2000

and 2933 to 3000 Please assist.

Regards

Noman khan

Labels (1)
Labels
1,176 Views
0 Likes
1 Solution

Accepted Solutions
tresB
Champion III
Champion III
‎2016-01-07 05:55 AM

Round(YourNumber, 1000)

View solution in original post

1,108 Views
8 Replies
Chanty4u
MVP
MVP
‎2016-01-07 05:53 AM

   Floor(Num('EXPRESSION'))

1,108 Views
0 Likes
Anonymous
Not applicable
‎2016-01-07 05:54 AM

try with Floor() & Ceil()...

how it is stored into data??

1,108 Views
0 Likes
amit_saini
Master III
Master III
‎2016-01-07 05:55 AM

Hi,

Check:

https://community.qlik.com/message/254814#254814

https://community.qlik.com/message/760272#760272

Thanks,

AS

1,108 Views
0 Likes
tresB
Champion III
Champion III
‎2016-01-07 05:55 AM

Round(YourNumber, 1000)

1,109 Views
sunny_talwar
MVP
MVP
‎2016-01-07 05:57 AM

Try this:

=Round(Number/1000)*1000

1,108 Views
Chanty4u
MVP
MVP
‎2016-01-07 05:57 AM

=num(round(urnum))

1,108 Views
0 Likes
noman212
Creator III
Creator III
‎2016-01-07 06:00 AM
Author

In response to tresB

Thanks Alot tresesco

1,108 Views
0 Likes
Chanty4u
MVP
MVP
‎2016-01-07 06:01 AM

hi,round.png

1,108 Views
0 Likes