topic QV Query.. in QlikView https://community.qlik.com/t5/QlikView/QV-Query/m-p/392549#M1156569 <HTML><HEAD></HEAD><BODY><P><SPAN class="GRcorrect">hello</SPAN> <SPAN class="GRcorrect">frnds</SPAN>...</P><P><SPAN class="GRcorrect">i</SPAN> had data of last 4 years of customers say 2009 2010 2011 2012</P><P><SPAN class="GRcorrect">i</SPAN> want to show the details of customers who were in the 2009 but not in the 2010 &amp; 2011...and also in the 2012 ...</P><P><SPAN class="GRcorrect">it</SPAN> means <SPAN class="GRcorrect">i</SPAN> want the customer list of those <SPAN class="GRcorrect">cutomers</SPAN> who were in the 2009 &amp; 2012 but not those customers who were new in the 2012....</P><P></P><P><SPAN class="GRcorrect">plz</SPAN> help asap..!!!</P></BODY></HTML> Fri, 01 Feb 2013 06:26:47 GMT 2013-02-01T06:26:47Z QV Query.. https://community.qlik.com/t5/QlikView/QV-Query/m-p/392549#M1156569 <HTML><HEAD></HEAD><BODY><P><SPAN class="GRcorrect">hello</SPAN> <SPAN class="GRcorrect">frnds</SPAN>...</P><P><SPAN class="GRcorrect">i</SPAN> had data of last 4 years of customers say 2009 2010 2011 2012</P><P><SPAN class="GRcorrect">i</SPAN> want to show the details of customers who were in the 2009 but not in the 2010 &amp; 2011...and also in the 2012 ...</P><P><SPAN class="GRcorrect">it</SPAN> means <SPAN class="GRcorrect">i</SPAN> want the customer list of those <SPAN class="GRcorrect">cutomers</SPAN> who were in the 2009 &amp; 2012 but not those customers who were new in the 2012....</P><P></P><P><SPAN class="GRcorrect">plz</SPAN> help asap..!!!</P></BODY></HTML> Fri, 01 Feb 2013 06:26:47 GMT https://community.qlik.com/t5/QlikView/QV-Query/m-p/392549#M1156569 2013-02-01T06:26:47Z Re: QV Query.. https://community.qlik.com/t5/QlikView/QV-Query/m-p/392550#M1156570 <HTML><HEAD></HEAD><BODY><P>Try like this <STRONG> </STRONG></P><P></P><P></P><P></P><P><STRONG>only({$&lt;Year={'2009','2012'}&gt;}Customer)</STRONG></P><P></P><P><STRONG>Hope it help you!!<BR /></STRONG></P></BODY></HTML> Fri, 01 Feb 2013 07:20:01 GMT https://community.qlik.com/t5/QlikView/QV-Query/m-p/392550#M1156570 sujeetsingh 2013-02-01T07:20:01Z Re: QV Query.. https://community.qlik.com/t5/QlikView/QV-Query/m-p/392551#M1156571 <HTML><HEAD></HEAD><BODY><P>bro dats not working.</P><P>its not showing any data.</P><P>:"(</P></BODY></HTML> Fri, 01 Feb 2013 07:36:49 GMT https://community.qlik.com/t5/QlikView/QV-Query/m-p/392551#M1156571 2013-02-01T07:36:49Z Re: QV Query.. https://community.qlik.com/t5/QlikView/QV-Query/m-p/392552#M1156572 <HTML><HEAD></HEAD><BODY><P>hiiii</P><P>try this</P><P>in script after load table using rowno()&nbsp; function </P><P>if(year1&lt;&gt;2010 and year1&lt;&gt; 2011,Only(customer))</P><P>using set analysis also show in file</P></BODY></HTML> Fri, 01 Feb 2013 07:49:34 GMT https://community.qlik.com/t5/QlikView/QV-Query/m-p/392552#M1156572 er_mohit 2013-02-01T07:49:34Z Re: QV Query.. https://community.qlik.com/t5/QlikView/QV-Query/m-p/392553#M1156573 <HTML><HEAD></HEAD><BODY><P>hi</P><P>see attachement</P></BODY></HTML> Fri, 01 Feb 2013 08:09:48 GMT https://community.qlik.com/t5/QlikView/QV-Query/m-p/392553#M1156573 2013-02-01T08:09:48Z Re: QV Query.. https://community.qlik.com/t5/QlikView/QV-Query/m-p/392554#M1156574 <HTML><HEAD></HEAD><BODY><P>it is having the same expression i think.</P><P></P><P>It is good</P></BODY></HTML> Fri, 01 Feb 2013 08:17:53 GMT https://community.qlik.com/t5/QlikView/QV-Query/m-p/392554#M1156574 sujeetsingh 2013-02-01T08:17:53Z