Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
slribeiro
Partner - Creator
Partner - Creator

Formating numbers

Greetings.

I need help.

How can I format a number like num(value,'##0') but with the thousand separator being the character '.

The ideia is to have numbers like 23'456.

Best regards

Simão Ribeiro

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Try

Replace(Num('23456','#.##0'),'.',Chr(39))

23456 is Your field.

View solution in original post

4 Replies
Anonymous
Not applicable

How about something like this using ascii character 145

=num(left('23456',2),'##')&chr(145)&num(right('23456',3),'##0')

antoniotiman
Master III
Master III

Try

Replace(Num('23456','#.##0'),'.',Chr(39))

23456 is Your field.

Anonymous
Not applicable

Good shout Antonio it should be chr(39)

slribeiro
Partner - Creator
Partner - Creator
Author

Many thanks.