Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV Query..

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..!!!

5 Replies
sujeetsingh
Master III
Master III

Try like this

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

Hope it help you!!

Not applicable
Author

bro dats not working.

its not showing any data.

:"(

er_mohit
Master II
Master II

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

Not applicable
Author

hi

see attachement

sujeetsingh
Master III
Master III

it is having the same expression i think.

It is good