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

Year

Hi

I am having 4 years suppose 2009, 2010, 2011, 2012. Now i am having customers in all the years. I have to display the customers who exists in 2009 but not in next two consecutive years but are regained in 2012. I only want to show the customers who were in 2009 & also at present but not in 2010 & 2011. I also don't want to show the customers others than of 2009.

Helppppppppp!!!!!!!!!!!!!!!!!!  on Urgent Basis

5 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi Vishn,

I don't know what type of chart you are using. However, if you use STRAIGHT chart. And the Year in LIST BOX

I have this example

YearCustomerUnit Purchase
2009James500
2010Tony310
2011Wales50
2012Tom108

So if I select 2009 (in List Box) you want to see customer in 2010,2011 excluding 2009 (which is the current selection)

My expression is, right click on th chart > expression > paste this SET ANALYSIS into the EDIT EXPRESSION BOX

sum( {$<Year = {$(=Only(Year)+1)}>}[Unit Purchase]) Click OK

Then for the 2nd year ADD (still at the expression)

and paste expression

sum( {$<Year = {$(=Only(Year)+2)}>}[Unit Purchase])

Click OK

With this, if you select 2010 in the list box customer for 2011 & 2012 will displayed, excluding current year selection.

Hope this help

Regards,

Gabriel

Not applicable
Author

Hey I am also working on this.

Gabriel I think you got the problem in wrong sense. I have to show the customers who were with me in 2009 but not in 2010 & 2011 but are regained in 2012.

I can sort out the customers which are in 2009 & 2012 by using the calculated dimension as =if(wildmatch(year,'2009',2010'),customername)

But here i also got the customers of 2012 which are new. Now how i should leave the new customers which were not in 2009 from 2012 customers.

Hope it explains you more

Not applicable
Author

please help

Not applicable
Author

Hi,

You probably have a field that states if the customer is new or old, or a date when the customer became a customer? If so, can't you just include it in the expression?

sujeetsingh
Master III
Master III

Hi,

go to this thread hope it help.

http://community.qlik.com/thread/71585?tstart=0