topic Aggr function set analysis VS if in QlikView https://community.qlik.com/t5/QlikView/Aggr-function-set-analysis-VS-if/m-p/602902#M683917 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Can anyone explain whats the difference between these 2 expressions:</P><P></P><P>1) sum({&lt;Confirmed={'1'}&gt;}aggr((($(vTimeSheetTime)+$(vApprovedTime)+$(vForecast))*[Project Day Rate]),ProjectCode,ConsultingMonth,Product,Sector))</P><P></P><P>and </P><P></P><P>2) sum(aggr(if(Confirmed=1,(($(vTimeSheetTime)+$(vApprovedTime)+$(vForecast))*[Project Day Rate])),ProjectCode,ConsultingMonth,Product,Sector))</P><P></P><P>It seems my report does work only with the 2) expression even though i don't have any confirmed codes at all.</P><P>If I use the first expression I just get the total of the current selection and qlikview seems to ignore set analysis.</P><P></P><P>Kind Regards, </P></BODY></HTML> Wed, 19 Feb 2014 10:54:07 GMT 2014-02-19T10:54:07Z Aggr function set analysis VS if https://community.qlik.com/t5/QlikView/Aggr-function-set-analysis-VS-if/m-p/602902#M683917 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Can anyone explain whats the difference between these 2 expressions:</P><P></P><P>1) sum({&lt;Confirmed={'1'}&gt;}aggr((($(vTimeSheetTime)+$(vApprovedTime)+$(vForecast))*[Project Day Rate]),ProjectCode,ConsultingMonth,Product,Sector))</P><P></P><P>and </P><P></P><P>2) sum(aggr(if(Confirmed=1,(($(vTimeSheetTime)+$(vApprovedTime)+$(vForecast))*[Project Day Rate])),ProjectCode,ConsultingMonth,Product,Sector))</P><P></P><P>It seems my report does work only with the 2) expression even though i don't have any confirmed codes at all.</P><P>If I use the first expression I just get the total of the current selection and qlikview seems to ignore set analysis.</P><P></P><P>Kind Regards, </P></BODY></HTML> Wed, 19 Feb 2014 10:54:07 GMT https://community.qlik.com/t5/QlikView/Aggr-function-set-analysis-VS-if/m-p/602902#M683917 2014-02-19T10:54:07Z