Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
jalanhart
Creator
Creator

Pie Chart only negative or zero values

What is a good way to troubleshoot this error message on a pie chart? 

I am trying to divide up the total value of inventory by it's type, and yes some have zero dollars on hand but there are no negative values. 

How can I get this pie chart working?

Labels (1)
2 Replies
Chanty4u
MVP
MVP

Try this 

IF(Sum(InventoryValue) > 0, Sum(InventoryValue))

Or 

Sum({<InventoryValue={">0"}>} InventoryValue)

 

Bhushan_Mahajan
Creator II
Creator II

@jalanhart Try rangesum