topic Re: If condition in set analysis in QlikView https://community.qlik.com/t5/QlikView/If-condition-in-set-analysis/m-p/401248#M1149404 <HTML><HEAD></HEAD><BODY><P>Nope, not a job for set analysis. Use an if statement.</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">If((Col1 &gt;= Addmonths(Today(),-6) and Col2 = 'Complete') or Col2 = 'Active', Col3)</SPAN></P></BODY></HTML> Thu, 23 May 2013 17:32:59 GMT Gysbert_Wassenaar 2013-05-23T17:32:59Z If condition in set analysis https://community.qlik.com/t5/QlikView/If-condition-in-set-analysis/m-p/401246#M1149402 <HTML><HEAD></HEAD><BODY><P>I have an expression like below , basically i want all Active values in Col2 and Complete values in Col2 for Past 6 months , when these 2 conditions are satisfied i want to get values in Col3 , Can someone please help me put this in set analysis</P><P></P><P>If( Col1 &gt;= Addmonths(Today()-6) and Col2 = ' Complete' and Col2 = 'Active', Col3 )</P><P></P><P>Thank you!</P></BODY></HTML> Thu, 23 May 2013 14:50:45 GMT https://community.qlik.com/t5/QlikView/If-condition-in-set-analysis/m-p/401246#M1149402 Anonymous 2013-05-23T14:50:45Z Re: If condition in set analysis https://community.qlik.com/t5/QlikView/If-condition-in-set-analysis/m-p/401247#M1149403 <HTML><HEAD></HEAD><BODY><P>Any help on this please?</P></BODY></HTML> Thu, 23 May 2013 16:00:49 GMT https://community.qlik.com/t5/QlikView/If-condition-in-set-analysis/m-p/401247#M1149403 Anonymous 2013-05-23T16:00:49Z Re: If condition in set analysis https://community.qlik.com/t5/QlikView/If-condition-in-set-analysis/m-p/401248#M1149404 <HTML><HEAD></HEAD><BODY><P>Nope, not a job for set analysis. Use an if statement.</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">If((Col1 &gt;= Addmonths(Today(),-6) and Col2 = 'Complete') or Col2 = 'Active', Col3)</SPAN></P></BODY></HTML> Thu, 23 May 2013 17:32:59 GMT https://community.qlik.com/t5/QlikView/If-condition-in-set-analysis/m-p/401248#M1149404 Gysbert_Wassenaar 2013-05-23T17:32:59Z Re: If condition in set analysis https://community.qlik.com/t5/QlikView/If-condition-in-set-analysis/m-p/401249#M1149405 <HTML><HEAD></HEAD><BODY><P>oh .. is the above if statement right ? i am not sure how to define all Active values and only Complete values for past 6 months. </P></BODY></HTML> Thu, 23 May 2013 17:37:48 GMT https://community.qlik.com/t5/QlikView/If-condition-in-set-analysis/m-p/401249#M1149405 Anonymous 2013-05-23T17:37:48Z