Discussion Board for collaboration related to QlikView App Development.
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
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?
There are multiple expresions in the table. making cell boreder invisible
will not help
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.
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
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.