topic Re: Add spaces between the value of a text dimension in App Development

Add spaces between the value of a text dimension

lotitolo — Tue, 08 Dec 2020 11:20:32 GMT

I have a text dimension with mixed values inside.

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

Taoufiq_Zarra — Tue, 08 Dec 2020 11:37:09 GMT

@lotitolo for example you can use :

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

output:

lotitolo — Tue, 08 Dec 2020 11:40:12 GMT

it works great! thank you 🙂