topic Aggr Embedded IFs in QlikView https://community.qlik.com/t5/QlikView/Aggr-Embedded-IFs/m-p/947077#M326176 <HTML><HEAD></HEAD><BODY><P>All, </P><P></P><P>I have a pretty lengthy If(Sum()) &gt; then statement, that populates the variance of Hours Worked Over Target hours, So right now i have a straight table with that looks Something like example below. I want to create two text boxes that displays the Count(distinct [Employee Name] has a positive variance, and one that has a Count(Distinct( [Employee Name]) that has a negative variance. The variance formula is a pretty extensive formula. Any recommendations? </P><P><IMG alt="variance.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/104056_variance.png" style="height: auto;" /></P></BODY></HTML> Thu, 05 Nov 2015 17:24:02 GMT 2015-11-05T17:24:02Z Aggr Embedded IFs https://community.qlik.com/t5/QlikView/Aggr-Embedded-IFs/m-p/947077#M326176 <HTML><HEAD></HEAD><BODY><P>All, </P><P></P><P>I have a pretty lengthy If(Sum()) &gt; then statement, that populates the variance of Hours Worked Over Target hours, So right now i have a straight table with that looks Something like example below. I want to create two text boxes that displays the Count(distinct [Employee Name] has a positive variance, and one that has a Count(Distinct( [Employee Name]) that has a negative variance. The variance formula is a pretty extensive formula. Any recommendations? </P><P><IMG alt="variance.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/104056_variance.png" style="height: auto;" /></P></BODY></HTML> Thu, 05 Nov 2015 17:24:02 GMT https://community.qlik.com/t5/QlikView/Aggr-Embedded-IFs/m-p/947077#M326176 2015-11-05T17:24:02Z Re: Aggr Embedded IFs https://community.qlik.com/t5/QlikView/Aggr-Embedded-IFs/m-p/947078#M326177 <HTML><HEAD></HEAD><BODY><P>Sum (Aggr (If(YourVarianceExpression &lt; 0, 1), [Employee Name]))</P></BODY></HTML> Thu, 05 Nov 2015 17:27:06 GMT https://community.qlik.com/t5/QlikView/Aggr-Embedded-IFs/m-p/947078#M326177 MK_QSL 2015-11-05T17:27:06Z Re: Aggr Embedded IFs https://community.qlik.com/t5/QlikView/Aggr-Embedded-IFs/m-p/947079#M326178 <HTML><HEAD></HEAD><BODY><P>Yep that was it, Thanks Manish!</P></BODY></HTML> Thu, 05 Nov 2015 17:49:46 GMT https://community.qlik.com/t5/QlikView/Aggr-Embedded-IFs/m-p/947079#M326178 2015-11-05T17:49:46Z