Number Format

[qlikviewaf]

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!

[vinieme12]

Use Round()

example =Round(Field)

Round ‒ QlikView

[qlikviewaf]

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]

You can use Num also

=Num(45.735,'##')

[qlikviewaf]

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]

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]

Hi,

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

$ #;-$ #

Marcus