topic Can you replace an aggr() by an set analysis in QlikView https://community.qlik.com/t5/QlikView/Can-you-replace-an-aggr-by-an-set-analysis/m-p/237084#M88189 <HTML><HEAD></HEAD><BODY><P>Hey</P><P>Does anybody has ever tried to replace and aggr() with a set analysis to get some more performance?</P><P>tnx</P><P></P><P></P></BODY></HTML> Thu, 11 Feb 2010 15:23:16 GMT timmy 2010-02-11T15:23:16Z Can you replace an aggr() by an set analysis https://community.qlik.com/t5/QlikView/Can-you-replace-an-aggr-by-an-set-analysis/m-p/237084#M88189 <HTML><HEAD></HEAD><BODY><P>Hey</P><P>Does anybody has ever tried to replace and aggr() with a set analysis to get some more performance?</P><P>tnx</P><P></P><P></P></BODY></HTML> Thu, 11 Feb 2010 15:23:16 GMT https://community.qlik.com/t5/QlikView/Can-you-replace-an-aggr-by-an-set-analysis/m-p/237084#M88189 timmy 2010-02-11T15:23:16Z Can you replace an aggr() by an set analysis https://community.qlik.com/t5/QlikView/Can-you-replace-an-aggr-by-an-set-analysis/m-p/237085#M88190 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>You can´t replace one for another because their purpose are diferent.</P><P>Set Analysis could be used to replace an IF() statement inside an aggregation like sum(), avg(), count().</P><P>In this cases the performance is quite the same, but there are somethings you can do only using the new Set Analysis statement. In most cases the real gain is in Set Analysis´s lower code complexity.</P><P>Best Regards,</P><P>Fernando</P></BODY></HTML> Thu, 11 Feb 2010 17:24:06 GMT https://community.qlik.com/t5/QlikView/Can-you-replace-an-aggr-by-an-set-analysis/m-p/237085#M88190 fernandotoledo 2010-02-11T17:24:06Z