topic Re: Calculation for in month using set analysis in QlikView https://community.qlik.com/t5/QlikView/Calculation-for-in-month-using-set-analysis/m-p/497010#M185827 <HTML><HEAD></HEAD><BODY><P>Brad,</P><P></P><P>Aggr does not accept the set analysis. Sum does.</P><P>So I would move the Set Analysis statement into the the Sum section.</P><P></P><P>Fabrice</P></BODY></HTML> Fri, 08 Nov 2013 08:57:57 GMT 2013-11-08T08:57:57Z Calculation for in month using set analysis https://community.qlik.com/t5/QlikView/Calculation-for-in-month-using-set-analysis/m-p/497009#M185826 <HTML><HEAD></HEAD><BODY><P>I have a statement which calculates the delayed orders as below;</P><P></P><P>Sum(Aggr(If((inLeveransDatum - Lev_Leveranstid)&gt; Villkor_inlev, 1, 0), [%InLevNr]))' with month as dimension.</P><P></P><P>i wish for this statement to be for the previous month in a table without the month dimension but my syntax is incorrect</P><P>any help would be greatly appreciated;</P><P></P><P>Sum(Aggr{&lt;inLeveransDatumMonth={'&gt;=$(=max(inLeveransDatumMonth)-1)&lt;=$(=max(inLeveransDatumMonth)-1)'}&gt;} If((inLeveransDatum - Lev_Leveranstid)&gt; Villkor_inlev, 1, 0), [%InLevNr]))</P><P></P><P>Best</P><P>Brad</P></BODY></HTML> Fri, 08 Nov 2013 08:24:38 GMT https://community.qlik.com/t5/QlikView/Calculation-for-in-month-using-set-analysis/m-p/497009#M185826 2013-11-08T08:24:38Z Re: Calculation for in month using set analysis https://community.qlik.com/t5/QlikView/Calculation-for-in-month-using-set-analysis/m-p/497010#M185827 <HTML><HEAD></HEAD><BODY><P>Brad,</P><P></P><P>Aggr does not accept the set analysis. Sum does.</P><P>So I would move the Set Analysis statement into the the Sum section.</P><P></P><P>Fabrice</P></BODY></HTML> Fri, 08 Nov 2013 08:57:57 GMT https://community.qlik.com/t5/QlikView/Calculation-for-in-month-using-set-analysis/m-p/497010#M185827 2013-11-08T08:57:57Z