topic how can we put numbers into integer in QlikView

how can we put numbers into integer

Mon, 26 Aug 2013 14:12:35 GMT

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

Re: how can we put numbers into integer

rajeshvaswani77 — Mon, 26 Aug 2013 14:16:03 GMT

Hi Helene,

Use the floor function

floor(1526321.25585)

would return 1526321

thanks,

Rajesh Vaswani

Re: how can we put numbers into integer

fernando_tonial — Mon, 26 Aug 2013 14:17:08 GMT

Hi, you can try the Num() Function.

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

Best Regards.

Tonial.

Re: how can we put numbers into integer

jpapador — Mon, 26 Aug 2013 14:19:07 GMT

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.