Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
Partner - Champion II
Partner - Champion II

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
Partner - Champion II
Partner - Champion II

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.