Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
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
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?


Partner - Creator II
Partner - Creator II

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

will not help

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.

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

Partner - Creator II
Partner - Creator II

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.