Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sergio0592
Specialist III
Specialist III

Issue with num format

Hi all,

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

Capture.JPG

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

1 Solution

Accepted Solutions
sunny_talwar

Try this:

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

View solution in original post

4 Replies
robert_mika
Master III
Master III

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


You need apostrophes..

Chanty4u
MVP
MVP

try to add single quotes  for 

'##0'

sunny_talwar

Try this:

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

sergio0592
Specialist III
Specialist III
Author

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

Capture2.JPG

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