Negative values and Treemap

The treemap component is able to handle negative colour intensities …. as long at least 1 intensity is positive. This means you need to add at least one row with an empty label field, 0 as value and 1% as intensity. As the label and value are both empty, it will not show up in the treemap itself.

This workaround is however not a solution in case of negative values. A negative value will simply not display. In most cases a simple warning message will suffice as it is probably an exception. In case it is not an exception you should advise to use another chart type for analysis. Like with pie charts, where negative values cannot be displayed.

Recent Related Posts
Femke Kooij is a dashboard and report designer, developer and educator specializing in SAP | BusinessObjects Dashboards (better known as Xcelsius) and Crystal Reports. She has also a lot of experience with other SAP | BusinessObjects toolings like, Web Intelligence (WebI), Information Design Tool (Universe Designer), BusinessObjects Data Services (BODS) and the overall server platform BusinessObjects Enterprise (Launchpad, CMC). She spends a lot of her time thinking about and sharing her knowledge of Xcelsius to others through her own blog. Lately she is exploring other visualization tools like Qlikview and Tableau. On the later she is also posting some experiences. Currently she is in the employment of Cognizant Technology Solutions. Her blog only contains her personal views, thoughts and opinions. It is not endorsed by Cognizant Technology Solutions nor does it constitute any official communication of Cognizant Technology Solutions.

This entry was posted in Components and tagged , , . Bookmark the permalink.

One Comment to Negative values and Treemap

  1. I do consider all the concepts you’ve introduced in your post. They are really convincing and will certainly work. Still, the posts are too quick for newbies. May just you please prolong them a bit from next time? Thanks for the post.