Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!

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

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