5 Replies Latest reply: Apr 14, 2016 10:34 AM by Marcus Sommer RSS

    Align bracketed number format

      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?

       

      error loading image