Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
retko1985
Creator II
Creator II

Text Box is trimming my text.

Hello,

I want to align my text by adding some spaces after the word, but it is not moving, but trimming.

I dont want to use text margin, because I want to muve just one part:

I want to have something like this in text box:

=if(vText=1,'Big Text','Small     ')

When clicked, it will switch text. Now I need to make it appear good by adding spaces.

Is here some way?

Thank you.

1 Solution

Accepted Solutions
prieper
Master II
Master II

Try to add an invisible character:

= IF(vText = 1, 'Big Text', 'Small      ' & CHR(127))

edit: typo: CHR(157) works on my computer as well, think that CHR(127) is better.

View solution in original post

1 Reply
prieper
Master II
Master II

Try to add an invisible character:

= IF(vText = 1, 'Big Text', 'Small      ' & CHR(127))

edit: typo: CHR(157) works on my computer as well, think that CHR(127) is better.