Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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 🙂