topic Pie Charts & Negative Data After Applying Filter in QlikView https://community.qlik.com/t5/QlikView/Pie-Charts-Negative-Data-After-Applying-Filter/m-p/292802#M585147 <HTML><HEAD></HEAD><BODY><P> So simple! Thats super thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 23 Aug 2011 14:05:04 GMT 2011-08-23T14:05:04Z Pie Charts & Negative Data After Applying Filter https://community.qlik.com/t5/QlikView/Pie-Charts-Negative-Data-After-Applying-Filter/m-p/292800#M585145 <HTML><HEAD></HEAD><BODY><P>I have a pie chart which shows total spend by customer. I am able to apply filters in the dahsboard by date so for example March to July spend. If a customer placed business in February, but then had a refund in March, the March spend for that customer is a negative value (which is ok). However when I filter the data to show March to July spend only my pie chart displays an error message which says "positive and negative values in chart" and displays no chart. I fully understand why it is doing this, but I want my data in a Pie Chart, and I want to be able to filter by date. Is there any way around this? Is there a way to get the pie chart to ignore negative values when filtering for example? Thanks. Jenny.</P></BODY></HTML> Tue, 23 Aug 2011 10:42:46 GMT https://community.qlik.com/t5/QlikView/Pie-Charts-Negative-Data-After-Applying-Filter/m-p/292800#M585145 2011-08-23T10:42:46Z Pie Charts & Negative Data After Applying Filter https://community.qlik.com/t5/QlikView/Pie-Charts-Negative-Data-After-Applying-Filter/m-p/292801#M585146 <HTML><HEAD></HEAD><BODY><P>Sure, try something like if(sum(sales)&gt;=0, sum(sales)) to filter negative values.</P></BODY></HTML> Tue, 23 Aug 2011 13:17:51 GMT https://community.qlik.com/t5/QlikView/Pie-Charts-Negative-Data-After-Applying-Filter/m-p/292801#M585146 danielrozental 2011-08-23T13:17:51Z Pie Charts & Negative Data After Applying Filter https://community.qlik.com/t5/QlikView/Pie-Charts-Negative-Data-After-Applying-Filter/m-p/292802#M585147 <HTML><HEAD></HEAD><BODY><P> So simple! Thats super thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 23 Aug 2011 14:05:04 GMT https://community.qlik.com/t5/QlikView/Pie-Charts-Negative-Data-After-Applying-Filter/m-p/292802#M585147 2011-08-23T14:05:04Z