Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to find returning customers, lost customers, new customers

Hi,

I am trying to build table with new, returning, lost customers.

Data is of last 3 years-2015,2016,2017

New Customer - Customer in 2017 only

Returning customer- Was customer in 2015, not n 2016, again customer in 2017

lost customer: was customer in 2015/2016 , not customer in 2017

I have fields : Customer-name, Year, Bookings.

I have seen blog posts how to do this in qlikview, but I am not sure how will this achieved in qliksense.

Thanks,

Akanksha

2 Replies
PaulVanSiclen
Employee
Employee

Hi Akansha,

Based on your description, blogs on how to do this with QlikView still apply to Qlik Sense because they were probably based on the powerful function called Set Analysis.

Another option would be to create columns for each of the years, then it could potentially be created with a simple list box.  In other words, your column names would be:

Customer-Name, 2015, 2016, 2017, Bookings

This can be achieved through the script or possibly even in the UI with Set Analysis....your choice.

jayaseelan
Creator III
Creator III

Hi Akanksha,

         Please post any example data, then we will work on it.

Thanks,