Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anil529106
Contributor III
Contributor III

I am unable add extra blank spaces between characters/words in qliksense "Text & Image" object...how can I do this??

I am unable add extra blank spaces between characters/words in qliksense "Text & Image" object...how can I do this??

11 Replies
aoy
Employee
Employee

Use Repeat(CHR(160),5)CHR(160) instead of Repeat(' ',5)


@anil529106 wrote:

I am unable add extra blank spaces between characters/words in qliksense "Text & Image" object...how can I do this??


 

rameshk1596
Contributor
Contributor

HI 

You can use left and right functions to achieve this.(Workaround)!!

Example :

Name field- RameshKannan

left(6)&' '&right(6)

Output - Ramesh Kannan

if it has to be generic use length of the field and use IF ELSE with left and right combination