Identifying inactive Customers

[#1]

Hi Guys. . !!

i am new to Qlikview. . and especially to Set Analysis. .

Can someone pls help me solve a problem of mine. .

I have a list of customers across different countries who have made business with our company in different months.

I need a expression which can give me the list of customers who are/were inactive in a particular month.

Definition of inactive: Customers who have transacted for the first time in the selected month or who have transacted after 8 consecutive months.

So the inactive-ness depends on the month which is selected.

Looking for some solutions. .

Thanks. . !!

[ali_hijazi]

Provide sample data or qvw document and I will give it a solution

[#3]

Small Correction:

The definition i had provided is for "New" Customers.

Definition for inactive customers : Customers who had transacted before 3 months but not in the selected month.

Customer Id	Month	Bookings	TAG
101	Jan	100
105	Feb	200
103	March	300
104	April	400
105	May	500
106	May	600
107	June	700
108	July	800
109	August	900
110	Sept	1000
101	Oct	1100	NEW
102	Oct	1200	NEW
111	Dec	1300

TAG column is what i want, Suppose my selection is October then according to the definitions emp id 101 and 102 are NEW since 102 is appearing for the first time and 101 is appearing after 8+ months, and emp id 103,104,105,106,107,108 are inactive in October since they have not transacted in August/September/October.

[sujeetsingh]

Follow this thread, you need to use the FirstSorted function to get this

FirstSortedValue()

[salto]

Hi,

An approximate expression for a Inactive Customer could be:

=if (Sum({<Month = {"$(<=month(addmonths(Max(Date),-3)))"},Year=,Date=>} Bookings > 0)

      and

     (Sum({<Month = {"$(=month(addmonths(Max(Date),0)))"},Year=,Date=>} Bookings = 0), 'Inactive')

Hope this helps...