topic Re: Indenting Space in Cell in QlikView

Indenting Space in Cell

adnan_rafiq — Sun, 11 Jan 2015 08:26:00 GMT

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

Re: Indenting Space in Cell

nagaiank — Sun, 11 Jan 2015 09:21:34 GMT

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?

Re: Indenting Space in Cell

adnan_rafiq — Sun, 11 Jan 2015 11:05:27 GMT

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

will not help

Re: Indenting Space in Cell

petter — Sun, 11 Jan 2015 18:34:51 GMT

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)

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.

Re: Indenting Space in Cell

Anonymous — Mon, 12 Jan 2015 00:32:32 GMT

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

Re: Indenting Space in Cell

adnan_rafiq — Sun, 22 Feb 2015 09:05:02 GMT

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.