Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Format numbers with all dots

Good morning,

I have to change the number format from this format eg 6.200.500 in 6.200,500

I have to replace the first dot on the right in comma, how can I do?

Thanks

1 Reply
vishsaggi
Champion III
Champion III

May be try this?

= Subfield(Numb, '.', 1)&'.'&Subfield(Numb,'.',2)&','&Subfield(Numb, '.',3)