Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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. . !!
Provide sample data or qvw document and I will give it a solution
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.
Follow this thread, you need to use the FirstSorted function to get this
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...