Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND 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
mark6505
Partner - Specialist III
Partner - Specialist III

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?