Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Champion II
Champion II

Use Round()

example =Round(Field)

Round ‒ QlikView

Highlighted
Creator
Creator

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

Highlighted

What you mean by having only the K??

Highlighted
Master III
Master III

You can use Num also

=Num(45.735,'##')

Highlighted
Creator
Creator

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

Highlighted

Try like this

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

Highlighted
Creator
Creator

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

Highlighted

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

Highlighted
Specialist III
Specialist III

Hi,

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

$ #;-$ #

Marcus