Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: how can we put numbers into integer

Hi Helene,


Use the floor function


floor(1526321.25585)


would return 1526321


thanks,

Rajesh Vaswani

fernando_tonial
Not applicable

Re: how can we put numbers into integer

Hi, you can try the Num() Function.

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

Best Regards.

Tonial.

jpapador
Not applicable

Re: how can we put numbers into integer

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.