Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Negative number format

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!

Labels (1)
2 Replies
crusader_
Partner - Specialist
Partner - Specialist

Hi,

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

Regards,

Andrei

sunny_talwar
MVP
MVP

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,

S