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: 
adnan_rafiq
Partner - Creator II
Partner - Creator II

Indenting Space in Cell

Dear All,

I have a client who want to align numbers right to cell in straight table

But issues comes in when we align it to close to line. So now we want to put some space between line and right aligned number

I tried putting space in number format, added space in expression nothing is working.

one method that works is putting some dot or character at end of space. which is off course is not acceptable.

Is there any way I can ident text like we can do in Excel cells

5 Replies
nagaiank
Specialist III
Specialist III

By adding another expression with a value of one space and with label as a space, you can achieve the following straight table. Will this be acceptable?

Capture.PNG

adnan_rafiq
Partner - Creator II
Partner - Creator II
Author

There are multiple expresions in the table. making cell boreder invisible

will not help

petter
Partner - Champion III
Partner - Champion III

As you observed QlikView strips out spaces and in fact also Unicode 00A0 (No-Break Space) so

the trick is to find another space-character:

Unicode 202F (Narrow No-Break Space) comes to the rescue:

Unicode Character 'NARROW NO-BREAK SPACE' (U+202F)

2015-01-11 Padding.PNG

Select it and press Ctrl+C and then place your cursor at the end of the Format String and paste it with Ctrl+V.

To the right on the screenshot above you see the utility called CharMap which is available as a standard program in Windows.

Unicode 2000 (En Quad) also does the trick it is much wider than 202F... But you can use multiple of them to get exactly the spacing you want.

Anonymous
Not applicable

Advice - do not use vertical lines, they have no visualization value anyway.  Just uncheck "Vertical..." checkboxes on the Style tab in the chart properties.  See how cleaner the table looks without these lines

adnan_rafiq
Partner - Creator II
Partner - Creator II
Author

Thanks a lot everyone,

I found out another way, surprisingly if we have space in number format that doesn't reflect in desktop client but in published version in web it shows space.

Thanks every one again from valuable suggestions.