topic Re: Issue with num format in QlikView

Issue with num format

sergio0592 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'd like format my expression number with separation between thousands . In the chart properties, it works when i put # ##0

But i try to get the same thing with num function, it goes wrong. I try with =num(sum(Orders),# ##0) and i have the message 'Error in expression'.

Regards

robert_mika — Wed, 07 Dec 2016 16:38:23 GMT

=num(sum(Orders),'# ##0')

You need apostrophes..

Chanty4u — Wed, 07 Dec 2016 16:41:42 GMT

try to add single quotes for

'##0'

sunny_talwar — Wed, 07 Dec 2016 16:52:42 GMT

Try this:

=Num(Sum(Orders), '# ##0', '.', ' ')

sergio0592 — Wed, 07 Dec 2016 17:07:39 GMT

Great Sunny, as usual !! Solutions suggested by Chanty and Robert return : Number # ##0

I will work on num function, it seems have numerous parameters!