Align bracketed number format

[#1]

Hi All,

As we all know, accountants generally like seeing negative numbers in brackets. We also (may) know that accountants like numbers lined up and justified.

How can we achieve these two conditions in a standard Qlikview pivot table or straight table?

With the default format:

#,##0;(#,##0)

the negative number is padded by the bracket and the positive number not padded by the bracket meaning the numbers are out of alignment slightly.

What is the simplest solution here?

[#2]

One possible solution is to change the font to a consistently spaced font (e.g. Courier) and enter a space at the end of the positive number format.

#,##0 ;(#,##0)

We are stuck with a particular font with this approach.

E.g. Arial and Tahoma (Qlikview default) do not line up

[sibrulotte]

Matt, that  was a valiant effort at answering, but alas,

nothing appears when adding a space at the end of formatting of positive numbers.

I am getting alot of negative feedback on our tables become of this.

Does someone else have an idea on the issue?

[marcus_sommer]

You could try it with a char like chr(8196) or a similar one. This is "nearly" perfect aligned:

num(sum([#STK K]), '#.##0' & chr(8196) & ';(#.##0)', ',', '.')

For more see: Whitespace character - Wikipedia, the free encyclopedia

- Marcus

[sibrulotte]

Good idea, unfortunatly, I am not getting an added space.

I'm using verdana, and have tried the num format suggested above with a slew of different fonts with no avail.

[marcus_sommer]

My check was with the font Tahoma:

- Marcus