Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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?