Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try :
(all if <10). '& Repeat(Chr(160),10)& [sample size]
Chr(160) : space
10: number of times u repeat it
Try :
(all if <10). '& Repeat(Chr(160),10)& [sample size]
Chr(160) : space
10: number of times u repeat it
thanks. using chr(160) instead of chr(32) did the trick. The repeat function is a nice touch too.
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.