topic Re: indirect set analysis in QlikView https://community.qlik.com/t5/QlikView/indirect-set-analysis/m-p/556477#M207731 <HTML><HEAD></HEAD><BODY><P>... or, as an alternative:</P><P></P><P>rangemax(0, sum(Sales))</P></BODY></HTML> Sun, 04 Aug 2013 19:12:46 GMT Oleg_Troyansky 2013-08-04T19:12:46Z indirect set analysis https://community.qlik.com/t5/QlikView/indirect-set-analysis/m-p/556475#M207729 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have a table of sales per sales person, for example:</P><P>SalesPerson,Sales</P><P>A,1000</P><P>A,2000</P><P>B,-5000</P><P>B,-400</P><P>G,1000</P><P></P><P></P><P>Now, i want to use a pie to show sales per sale person, but my problem is that because the total sales of sales person "b" is less then negative so the pie could not work. how can i exclude the sales person that the total sales (according to selection) is less the zero ?</P><P></P><P>Meany thanks</P></BODY></HTML> Sun, 04 Aug 2013 18:03:42 GMT https://community.qlik.com/t5/QlikView/indirect-set-analysis/m-p/556475#M207729 m4u 2013-08-04T18:03:42Z Re: indirect set analysis https://community.qlik.com/t5/QlikView/indirect-set-analysis/m-p/556476#M207730 <HTML><HEAD></HEAD><BODY><P>1. Don't use pie in this case, it's misleading. Use bar chart.</P><P>2. If you still want to use pie: =if( sum(Sales) &gt; 0, sum(Sales))</P></BODY></HTML> Sun, 04 Aug 2013 18:55:57 GMT https://community.qlik.com/t5/QlikView/indirect-set-analysis/m-p/556476#M207730 luciancotea 2013-08-04T18:55:57Z Re: indirect set analysis https://community.qlik.com/t5/QlikView/indirect-set-analysis/m-p/556477#M207731 <HTML><HEAD></HEAD><BODY><P>... or, as an alternative:</P><P></P><P>rangemax(0, sum(Sales))</P></BODY></HTML> Sun, 04 Aug 2013 19:12:46 GMT https://community.qlik.com/t5/QlikView/indirect-set-analysis/m-p/556477#M207731 Oleg_Troyansky 2013-08-04T19:12:46Z