topic Re: Align bracketed number format in QlikView

Align bracketed number format

Wed, 12 May 2010 05:18:39 GMT

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?

Align bracketed number format

Wed, 12 May 2010 05:38:09 GMT

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

Re: Align bracketed number format

sibrulotte — Thu, 14 Apr 2016 13:20:36 GMT

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?

Re: Align bracketed number format

marcus_sommer — Thu, 14 Apr 2016 13:53:02 GMT

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

Re: Align bracketed number format

sibrulotte — Thu, 14 Apr 2016 14:29:08 GMT

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.

Re: Align bracketed number format

marcus_sommer — Thu, 14 Apr 2016 14:34:54 GMT

My check was with the font Tahoma:

- Marcus