Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewaf
Creator
Creator

Number Format

Hi Guys,

this is what i have in my app.

I would like to have just thousand ,  for example 9.532, i would like to see only 10 (rounded)

for 45.735 i would like to see 46

for 19.106 i would like to see 19

I tried to change the format pattern, but i didnt get the result expected.

Any advice how to setup the format pattern?

Thank you!

NUMBER FORMAT.png

16 Replies
vinieme12
Champion III
Champion III

Use Round()

example =Round(Field)

Round ‒ QlikView

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
qlikviewaf
Creator
Creator
Author

what about having only the K ? (e.g. for 45.735 i would like to see 46)

avinashelite

What you mean by having only the K??

prma7799
Master III
Master III

You can use Num also

=Num(45.735,'##')

qlikviewaf
Creator
Creator
Author

as you see now i have on the table 45.735 - i would like to see only 45

avinashelite

Try like this

Round(Field/expression) this will give the desired result

qlikviewaf
Creator
Creator
Author

in this way i have 46.000 i would like to have only 46, without the 000

avinashelite

Did you tries the way we suggested it will give the exact result what your excepting

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Hi,

change your format pattern to remove everything after the decimal point:

$ #;-$ #

Marcus