topic If Statement in QlikView https://community.qlik.com/t5/QlikView/If-Statement/m-p/659273#M1072025 <HTML><HEAD></HEAD><BODY><P><IMG alt="Screenshot.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/64168_Screenshot.png" style="width: 744px; height: 388px;" /></P><P>In the Above table I need for the Breed to be calculated based on the Head Placed column. If the amount of any Breed is more than 80% of the total Head then that Breed will be used in naming, If not then it will be called "MIXED". Any assistance on this will be greatly appreciated.</P></BODY></HTML> Mon, 11 Aug 2014 19:40:57 GMT Anonymous 2014-08-11T19:40:57Z If Statement https://community.qlik.com/t5/QlikView/If-Statement/m-p/659273#M1072025 <HTML><HEAD></HEAD><BODY><P><IMG alt="Screenshot.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/64168_Screenshot.png" style="width: 744px; height: 388px;" /></P><P>In the Above table I need for the Breed to be calculated based on the Head Placed column. If the amount of any Breed is more than 80% of the total Head then that Breed will be used in naming, If not then it will be called "MIXED". Any assistance on this will be greatly appreciated.</P></BODY></HTML> Mon, 11 Aug 2014 19:40:57 GMT https://community.qlik.com/t5/QlikView/If-Statement/m-p/659273#M1072025 Anonymous 2014-08-11T19:40:57Z Re: If Statement https://community.qlik.com/t5/QlikView/If-Statement/m-p/659274#M1072026 <HTML><HEAD></HEAD><BODY><P>I think using aggr is your solution: </P><P>if(sum([head placed]) &gt; sum(aggr(sum([head placed]), [group cd]))*80,'MIXED',[breed])</P></BODY></HTML> Mon, 11 Aug 2014 19:59:41 GMT https://community.qlik.com/t5/QlikView/If-Statement/m-p/659274#M1072026 2014-08-11T19:59:41Z