Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how can we put numbers into integer

Hello,

i would like to know if it is possible to put figures into integers and express then in MEUR.

For example if i have this number in a graph/text box....:

1526321.25585

I want to obtain this: 1 526 321

Thank you, Helene

3 Replies
rajeshvaswani77
Specialist III
Specialist III

Hi Helene,


Use the floor function


floor(1526321.25585)


would return 1526321


thanks,

Rajesh Vaswani

fernando_tonial
Partner - Specialist
Partner - Specialist

Hi, you can try the Num() Function.

Num(FieldNumber,'# ##0') As FieldNumber

Best Regards.

Tonial.

Don't Worry, be Qlik.
jpapador
Partner - Specialist
Partner - Specialist

If it's already in a chart.  Go to the number tab choose integer.  Then the in the box where it says "thousand separator" replace the comma and just hit the space bar.