topic Re: Please Help in QlikView https://community.qlik.com/t5/QlikView/Please-Help/m-p/691531#M250269 <HTML><HEAD></HEAD><BODY><P>That should be a relatively simple if statement</P><P>if SPD date is less than current date minus 185.5 then Non Eligible else Eligible </P></BODY></HTML> Thu, 09 Oct 2014 23:02:11 GMT Anonymous 2014-10-09T23:02:11Z Please Help https://community.qlik.com/t5/QlikView/Please-Help/m-p/691530#M250268 <HTML><HEAD></HEAD><BODY><P>Hi !!</P><P></P><P>Problem I am facing is - </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">As per Scenario i have pasted Below - current date [take 04/01/2014] </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">and here SPD date is [25/08/2014] , which&nbsp; makes member non eligible, because member's SPD Date Falls under Last Six Month From Current Selection.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Please Help me In Logic To Rectify Eligible and Non Eligible.<BR /></SPAN></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1900px;"><TBODY><TR><TD align="right" class="xl63" height="20" width="64">301028</TD><TD align="right" class="xl63" style="border-left: none;" width="64">2585906</TD><TD class="xl63" style="border-left: none;" width="64">Pragya Sinha</TD><TD class="xl63" style="border-left: none;" width="64">Lucknow</TD><TD class="xl63" style="border-left: none;" width="64">Active</TD><TD align="right" class="xl63" style="border-left: none;" width="64">0</TD><TD class="xl63" style="border-left: none;" width="64"> </TD><TD align="right" class="xl63" style="border-left: none;" width="64">0</TD><TD class="xl63" style="border-left: none;" width="64"> </TD><TD align="right" class="xl63" style="border-left: none;" width="64">33200</TD><TD align="right" class="xl63" style="border-left: none;" width="64">0</TD><TD align="right" class="xl64" style="border-left: none;" width="75">6/1/2015</TD><TD align="right" class="xl63" style="border-left: none;" width="64">10</TD><TD align="right" class="xl64" style="border-left: none;" width="75">8/25/2014</TD><TD class="xl63" style="border-left: none;" width="64">No</TD><TD class="xl63" style="border-left: none;" width="64">25 - White STU</TD><TD class="xl63" style="border-left: none;" width="64">White</TD><TD class="xl63" style="border-left: none;" width="64">Studio</TD><TD class="xl63" style="border-left: none;" width="64">Noida</TD><TD align="right" class="xl63" style="border-left: none;" width="64">201301</TD><TD class="xl64" style="border-left: none;" width="75"> </TD><TD class="xl63" style="border-left: none;" width="64"> </TD><TD align="right" class="xl63" style="border-left: none;" width="64">9.2E+11</TD><TD class="xl63" style="border-left: none;" width="64"></TD><TD class="xl63" style="border-left: none;" width="64"></TD><TD class="xl63" style="border-left: none;" width="64"> </TD><TD class="xl63" style="border-left: none;" width="64"> </TD><TD align="right" class="xl63" style="border-left: none;" width="64">0</TD><TD class="xl63" style="border-left: none;" width="75">Not Eligible</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks In Advance. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /> </P></BODY></HTML> Thu, 09 Oct 2014 11:24:28 GMT https://community.qlik.com/t5/QlikView/Please-Help/m-p/691530#M250268 2014-10-09T11:24:28Z Re: Please Help https://community.qlik.com/t5/QlikView/Please-Help/m-p/691531#M250269 <HTML><HEAD></HEAD><BODY><P>That should be a relatively simple if statement</P><P>if SPD date is less than current date minus 185.5 then Non Eligible else Eligible </P></BODY></HTML> Thu, 09 Oct 2014 23:02:11 GMT https://community.qlik.com/t5/QlikView/Please-Help/m-p/691531#M250269 Anonymous 2014-10-09T23:02:11Z