Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
ronman10
Creator
Creator

Remove error message from Tree Map

Hi Guys,

I have created a tree map showing values as well as % share of business done, country wise.  What I want is to remove the error message which is displayed below the tree map which says "* the data set contains negative or zero values which cannot be displayed." How do I get rid of this? I read in a thread (link below) that it can be removed using 'calculation condition' in Add ons. However, I am not sure how the expression would be applied in case of 0 values or negatives, including negative percentages. Any suggestions on this?

How do I show a blank when there is negative or zero value?

Best Regards,

Rony

3 Replies
Mark_Little
Luminary
Luminary

Hi,

Not sure of a way to just remove the message as an option.

The only way i can think of is to get rid of the message is to get rid of the zeros or negative values.

Something like

IF(Sum(Value)>0,Sum(Value))

The reason for the message is to tell you it isn't really giving you a true representation of your data.

Mark

ronman10
Creator
Creator
Author

Hi Mark,

Thank you for your response.

Rony

shephali23
Contributor III
Contributor III

How were you able to show %share and does the chart show data points upon hover?