Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Partner
Partner

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
Highlighted
Valued Contributor III

Re: Indenting Space in Cell

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

Highlighted
Partner
Partner

Re: Indenting Space in Cell

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

will not help

Highlighted
MVP
MVP

Re: Indenting Space in Cell

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.

Highlighted
Esteemed Contributor III

Re: Indenting Space in Cell

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

Highlighted
Partner
Partner

Re: Indenting Space in Cell

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.