Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
toddbuss
Creator
Creator

simply insert a space between text values

I'm trying to insert a bit of space into a footnote  (two spaces after a period).  Qlik Sense appears to be cleaning up my extra spaces and I don't want it to.  I tried typing the spaces withing the text, and I tried inserting chr(32) to no avail.  This is a trivial matter, but irritating.

my footnote text:

='Results are Based on Inpatient sampling of 10 records per week (all if <10). '& chr(32) & [sample size]

thanks,

Todd

1 Solution

Accepted Solutions
OmarBenSalem

Try :

(all if <10). '& Repeat(Chr(160),10)& [sample size]

Chr(160) : space

10: number of times u repeat it

View solution in original post

3 Replies
OmarBenSalem

Try :

(all if <10). '& Repeat(Chr(160),10)& [sample size]

Chr(160) : space

10: number of times u repeat it

toddbuss
Creator
Creator
Author

thanks.  using chr(160) instead of chr(32) did the trick.  The repeat function is a nice touch too.

toddbuss
Creator
Creator
Author

To revisit this thread, I'm trying to insert spaces within a derived title, and Qlik is so smart that it removes my spacing to enforce "good design".  The only work-around I found is to create  several separate text-boxes as my title, but it's a pain to keep rearranging them to get something that approximates five space characters between them.  If anyone has a better solution, I'd love to hear it.  --thanks.