Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Highlighted
sujeetsingh
Honored Contributor III

Re: QV Query..

Try like this

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

Hope it help you!!

Not applicable

Re: QV Query..

bro dats not working.

its not showing any data.

:"(

er_mohit
Honored Contributor II

Re: QV Query..

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

Re: QV Query..

hi

see attachement

sujeetsingh
Honored Contributor III

Re: QV Query..

it is having the same expression i think.

It is good