how can we put numbers into integer - Qlik Community

Report Inappropriate Content · ‎2013-08-26

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

rajeshvaswani77 · ‎2013-08-26

Hi Helene,

Use the floor function

floor(1526321.25585)

would return 1526321

thanks,

Rajesh Vaswani

fernando_tonial · ‎2013-08-26

Hi, you can try the Num() Function.

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

Best Regards.

Tonial.

Don't Worry, be Qlik.

jpapador · ‎2013-08-26

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.