Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
lotitolo
Contributor III
Contributor III

Add spaces between the value of a text dimension

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

ValueExpected Value
56575 657
1393213 932
99099 909
7134671 346
76477 647
111136111 136
N/AN/A
N/AN/A
0.47%0.47%
1.90%1.90%
37%37%
1 Solution

Accepted Solutions
Taoufiq_Zarra

@lotitolo  for example you can use :

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

output:

Capture.PNG

Capture.PNG

Capture.PNG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@lotitolo  for example you can use :

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

output:

Capture.PNG

Capture.PNG

Capture.PNG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
lotitolo
Contributor III
Contributor III
Author

it works great! thank you 🙂