topic Help with Set Analysis expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-expression/m-p/164904#M37429 <HTML><HEAD></HEAD><BODY><P>Sorry... that should read</P><P>I want to calculate a column using Set Analysis (OrderDate &lt;= Monthstart(YearMonth) + 42 days)</P><P>thanks</P></BODY></HTML> Wed, 26 May 2010 10:24:58 GMT bismart 2010-05-26T10:24:58Z Help with Set Analysis expression https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-expression/m-p/164903#M37428 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Can anyone help with Set analysis statement which would solve my issue please</P><P>Thanks...</P><P>YearMonth OrderDate Item Qty<BR />201001 01/01/2010 A 2 A<BR />201001 20/01/2010 A 2 B<BR />201002 05/02/2010 A 2 C<BR />201003 10/03/2010 A 2 D<BR />201003 20/03/2010 A 2 E<BR />201004 02/04/2010 A 2 F<BR />201004 15/04/2010 A 2 G<BR />201004 16/04/2010 A 2 H</P><P>I want to calculate a column using Set Analysis (OrderDate &gt;= Monthstart(YearMonth) + 42 days)</P><P>201001 A 6 A+B+C Upto 6 weeks (42 days) from start of month for field YearMonth (i.e. 201001 = 01/01/2010 etc.)<BR />201002 A 4 C+D<BR />201003 A 6 D+E+F<BR />201004 A 6 F+G+H</P></BODY></HTML> Wed, 26 May 2010 09:40:30 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-expression/m-p/164903#M37428 bismart 2010-05-26T09:40:30Z Help with Set Analysis expression https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-expression/m-p/164904#M37429 <HTML><HEAD></HEAD><BODY><P>Sorry... that should read</P><P>I want to calculate a column using Set Analysis (OrderDate &lt;= Monthstart(YearMonth) + 42 days)</P><P>thanks</P></BODY></HTML> Wed, 26 May 2010 10:24:58 GMT https://community.qlik.com/t5/QlikView/Help-with-Set-Analysis-expression/m-p/164904#M37429 bismart 2010-05-26T10:24:58Z