QV Query..

[#1]

hello frnds...

i had data of last 4 years of customers say 2009 2010 2011 2012

i want to show the details of customers who were in the 2009 but not in the 2010 & 2011...and also in the 2012 ...

it means i want the customer list of those cutomers who were in the 2009 & 2012 but not those customers who were new in the 2012....

plz help asap..!!!

[sujeetsingh]

Try like this

only({$<Year={'2009','2012'}>}Customer)

Hope it help you!!

[#3]

bro dats not working.

its not showing any data.

:"(

[er_mohit]

hiiii

try this

in script after load table using rowno()  function

if(year1<>2010 and year1<> 2011,Only(customer))

using set analysis also show in file

[#5]

hi

see attachement

[sujeetsingh]

it is having the same expression i think.

It is good