topic Re: Identifying inactive Customers in QlikView

Identifying inactive Customers

Sun, 23 Nov 2014 15:44:58 GMT

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

Re: Identifying inactive Customers

ali_hijazi — Sun, 23 Nov 2014 20:21:04 GMT

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

Re: Identifying inactive Customers

Mon, 24 Nov 2014 08:10:09 GMT

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.

Re: Identifying inactive Customers

sujeetsingh — Mon, 24 Nov 2014 08:23:07 GMT

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

FirstSortedValue()

Re: Identifying inactive Customers

salto — Mon, 24 Nov 2014 08:27:11 GMT

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