Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
alis2063
Creator III
Creator III

Identify the New customer based on Logic

Hi Guys,

I am looking for very good dynamic approach to fulfill the requirement 

I have a list of customers  including the invoice date so basically i want to build the KPI  for New Customer

and New Customer is the customer who has purchase something recently and second latest transaction would be happened  more the 60 days earlier then it would be considered as  'New Customer'

Below is Customers with Invoice Date,

CustomerDateCustomer Type
A22-01-2018New
A01-01-2019New
A05-01-2019New
A11-01-2019New
A21-07-2019New
B02-01-2019Existing
B21-01-2019Existing
B06-02-2019Existing
C27-12-2018Existing
C02-01-2019Existing
C05-01-2019Existing
C05-03-2019Existing

 

Something like that

For Customer A-

Max Date is 21-07-2019

Second  Latest Transaction is 11-01-2019

The diff of above date is >60

 

It should be dynamic  if i select month the further calculation can be done on the fly .

 

Regards,

Ali

 

Labels (2)
11 Replies
alis2063
Creator III
Creator III
Author

Hi Tresesco,

I have attached the doc with output explained in detail,

Also  i have removed the extension  and included the in built KPISnapshot New CS.png

sunny_talwar

Hi, I am not @tresesco , but you can try this

Count(DISTINCT {<Customer={"=Max(Date)-Max({<Date = {[<$(=Max(Date))]}>}Date)>60"}>}Customer)

Basically adding another set analysis for the second max date which is saying that include all dates which are less than the max date and find there max.