topic Sum Check in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Sum-Check-in-Set-Analysis/m-p/1416610#M427816 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a situation, where I want to ignore values in some field based on the sum of another field.</P><P>Here is the example (look at attached QVW). I have a list of contracts, sale amounts and some other amount. I want to do the sum of sales for those contracts and specify in set analysis that I want to do SUM of Sales only for those contracts, which has the SUM of Amount more then 0.</P><P>Therefore in provided QVW I want a sum of Contracts 1 and 2. for Contract 3 the Sum of Amount is 0, so those should be ignored.</P><P></P><P>Please advise.</P><P>Thank you.</P></BODY></HTML> Thu, 14 Sep 2017 10:40:27 GMT retko1985 2017-09-14T10:40:27Z Sum Check in Set Analysis https://community.qlik.com/t5/QlikView/Sum-Check-in-Set-Analysis/m-p/1416610#M427816 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a situation, where I want to ignore values in some field based on the sum of another field.</P><P>Here is the example (look at attached QVW). I have a list of contracts, sale amounts and some other amount. I want to do the sum of sales for those contracts and specify in set analysis that I want to do SUM of Sales only for those contracts, which has the SUM of Amount more then 0.</P><P>Therefore in provided QVW I want a sum of Contracts 1 and 2. for Contract 3 the Sum of Amount is 0, so those should be ignored.</P><P></P><P>Please advise.</P><P>Thank you.</P></BODY></HTML> Thu, 14 Sep 2017 10:40:27 GMT https://community.qlik.com/t5/QlikView/Sum-Check-in-Set-Analysis/m-p/1416610#M427816 retko1985 2017-09-14T10:40:27Z Re: Sum Check in Set Analysis https://community.qlik.com/t5/QlikView/Sum-Check-in-Set-Analysis/m-p/1416611#M427817 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>Sum({&lt;Contract={"=Sum(Amount)&gt;0"}&gt;}Sales)</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176545_Capture.JPG" style="height: 155px; width: 620px;" /></P></BODY></HTML> Thu, 14 Sep 2017 10:42:52 GMT https://community.qlik.com/t5/QlikView/Sum-Check-in-Set-Analysis/m-p/1416611#M427817 tresB 2017-09-14T10:42:52Z Re: Sum Check in Set Analysis https://community.qlik.com/t5/QlikView/Sum-Check-in-Set-Analysis/m-p/1416612#M427818 <HTML><HEAD></HEAD><BODY><P>This?</P><P><STRONG>Sum({&lt;Amount = {'&gt;0'}&gt;} Sales)</STRONG></P></BODY></HTML> Thu, 14 Sep 2017 10:43:11 GMT https://community.qlik.com/t5/QlikView/Sum-Check-in-Set-Analysis/m-p/1416612#M427818 Anil_Babu_Samineni 2017-09-14T10:43:11Z