Discussion board where members can get started with QlikView.
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..!!!
Try like this
Hope it help you!!
bro dats not working.
its not showing any data.
in script after load table using rowno() function
if(year1<>2010 and year1<> 2011,Only(customer))
using set analysis also show in file
it is having the same expression i think.
It is good