topic Can this expression be optimized? in QlikView https://community.qlik.com/t5/QlikView/Can-this-expression-be-optimized/m-p/325984#M120043 <HTML><HEAD></HEAD><BODY><P>Hi beanz,</P><P></P><P>try using</P><P>=Avg({$&lt;Institution= p(Institution2) &gt;} [Actual value])</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Tue, 06 Sep 2011 10:07:38 GMT swuehl 2011-09-06T10:07:38Z Can this expression be optimized? https://community.qlik.com/t5/QlikView/Can-this-expression-be-optimized/m-p/325983#M120042 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an expression : =Avg({$&lt;Institution={'$(=concat(Institution2,chr(39)&amp;','&amp;chr(39)))'}&gt;} [Actual value]) which works perfectly BUT seems to slow down my Qlikview app. quite a bit. - I get an hourglass for a few seconds on the radar chart that this expression is being used on.</P><P></P><P>It could be a long shot, but there could be a more efficient approach??</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 06 Sep 2011 09:55:04 GMT https://community.qlik.com/t5/QlikView/Can-this-expression-be-optimized/m-p/325983#M120042 2011-09-06T09:55:04Z Can this expression be optimized? https://community.qlik.com/t5/QlikView/Can-this-expression-be-optimized/m-p/325984#M120043 <HTML><HEAD></HEAD><BODY><P>Hi beanz,</P><P></P><P>try using</P><P>=Avg({$&lt;Institution= p(Institution2) &gt;} [Actual value])</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Tue, 06 Sep 2011 10:07:38 GMT https://community.qlik.com/t5/QlikView/Can-this-expression-be-optimized/m-p/325984#M120043 swuehl 2011-09-06T10:07:38Z