topic More Than 2 Condition (Date Comaprison) in Set Analysis expression in QlikView https://community.qlik.com/t5/QlikView/More-Than-2-Condition-Date-Comaprison-in-Set-Analysis-expression/m-p/207845#M63467 <HTML><HEAD></HEAD><BODY><P>In this application i m having one date field that is<BR />-Recivedate , another one date field that is First Disb date.(I am using this one to<BR />make selection.....) now i want one more expression in union to that<BR /> this expression ...<BR />Where if Recieve Date is greater than First disb date(or in other<BR />words -Month(RecivedDate )should be greater than Month (Selected)<BR />---This field is coming from First DISB Date then all my fileno from<BR />aug2001 to till my selection.......<BR /><BR />Can you suggest me sumthing ......<BR />You can just gimme suggestison(in set analysis) rest i can apply ....<BR />According to me expression should be like this...<BR /><BR />=COUNT( {1&lt;YM={"&gt;=$(=MonthName(DATE('</P><DIV id=":zw">28/08/2001')))&lt;=$(=MAX(YM))"}, Rmonth={"&gt;MonthName'}&gt;}<BR />DISTINCT FILENO)<BR />But this is not working .....<BR />Any guesses<BR /><BR />QVW(Doccument ) is attached for your understanding and refrence..........<BR /></DIV></BODY></HTML> Sat, 18 Sep 2010 15:24:50 GMT 2010-09-18T15:24:50Z More Than 2 Condition (Date Comaprison) in Set Analysis expression https://community.qlik.com/t5/QlikView/More-Than-2-Condition-Date-Comaprison-in-Set-Analysis-expression/m-p/207845#M63467 <HTML><HEAD></HEAD><BODY><P>In this application i m having one date field that is<BR />-Recivedate , another one date field that is First Disb date.(I am using this one to<BR />make selection.....) now i want one more expression in union to that<BR /> this expression ...<BR />Where if Recieve Date is greater than First disb date(or in other<BR />words -Month(RecivedDate )should be greater than Month (Selected)<BR />---This field is coming from First DISB Date then all my fileno from<BR />aug2001 to till my selection.......<BR /><BR />Can you suggest me sumthing ......<BR />You can just gimme suggestison(in set analysis) rest i can apply ....<BR />According to me expression should be like this...<BR /><BR />=COUNT( {1&lt;YM={"&gt;=$(=MonthName(DATE('</P><DIV id=":zw">28/08/2001')))&lt;=$(=MAX(YM))"}, Rmonth={"&gt;MonthName'}&gt;}<BR />DISTINCT FILENO)<BR />But this is not working .....<BR />Any guesses<BR /><BR />QVW(Doccument ) is attached for your understanding and refrence..........<BR /></DIV></BODY></HTML> Sat, 18 Sep 2010 15:24:50 GMT https://community.qlik.com/t5/QlikView/More-Than-2-Condition-Date-Comaprison-in-Set-Analysis-expression/m-p/207845#M63467 2010-09-18T15:24:50Z