topic Negative number format in QlikView

Negative number format

Thu, 29 Jan 2015 13:52:34 GMT

Does anybody know if there's a way to make all negative numbers in parenthesis and give them a red color for the whole document, instead of manually doing it for every chart? In other words, can I do this in the script? Thank you!

Re: Negative number format

crusader_ — Thu, 29 Jan 2015 13:54:53 GMT

Hi,

To give color to values is not possible I suppose. Especially when you work with aggregation in charts.

Regards,

Andrei

Re: Negative number format

sunny_talwar — Thu, 29 Jan 2015 13:59:55 GMT

For parenthesis you can go to document properties (Ctrl + Alt + D) and go to Number tab and drag on all the field names and use give it whatever format you want to give it. For instance $#,##0.00;($#,##0.00) (Negative Number dollar number will be with parenthesis)

Hope this helps.

Best,