Add spaces between the value of a text dimension

[lotitolo]

Hi

I have a text dimension with mixed values inside.

• Integers
• Percentages
• Null values

I can't find a native function to add spaces every 3 characters to separate the integers and bring a better reading of them.

I can't do anything about the data source, I don't have access to. I have to find a way to do it from Qlik Sense.

Do you know how I can do this?

Regards

Value	Expected Value
5657	5 657
13932	13 932
9909	9 909
71346	71 346
7647	7 647
111136	111 136
N/A	N/A
N/A	N/A
0.47%	0.47%
1.90%	1.90%
37%	37%

[Taoufiq_Zarra · Accepted solution]

@lotitolo  for example you can use :

=if( WildMatch(Value,'*%*')>0 or isnum(Value)=0,Value,Num(Value,'# ##0','.',' '))

output:

[lotitolo]

it works great! thank you 🙂