topic Aggr in if statement within set analysis? in QlikView https://community.qlik.com/t5/QlikView/Aggr-in-if-statement-within-set-analysis/m-p/1047113#M940230 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i am new in qlikview, i have some question. in expression if i use this query:</P><P></P><P>=aggr(if(Month=Contract_Month and Year=Contract_Year,sum({&lt;Scope={'Marketing'},MaterialTypeSales={'CPO'},DataVersion={'1'}&gt;}Qty)),Month,Year,Contract_Month,Contract_Year)</P><P></P><P>it's showing the Sum(Qty).</P><P></P><P>but if i remove the aggregation, why the calculation is false / not showing?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 04 Feb 2016 09:13:34 GMT 2016-02-04T09:13:34Z Aggr in if statement within set analysis? https://community.qlik.com/t5/QlikView/Aggr-in-if-statement-within-set-analysis/m-p/1047113#M940230 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i am new in qlikview, i have some question. in expression if i use this query:</P><P></P><P>=aggr(if(Month=Contract_Month and Year=Contract_Year,sum({&lt;Scope={'Marketing'},MaterialTypeSales={'CPO'},DataVersion={'1'}&gt;}Qty)),Month,Year,Contract_Month,Contract_Year)</P><P></P><P>it's showing the Sum(Qty).</P><P></P><P>but if i remove the aggregation, why the calculation is false / not showing?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 04 Feb 2016 09:13:34 GMT https://community.qlik.com/t5/QlikView/Aggr-in-if-statement-within-set-analysis/m-p/1047113#M940230 2016-02-04T09:13:34Z