Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
madnanansari
Creator
Creator

New & Repeat customers

I have a retail sales database with the below information:

Date

Invoice No

Customer No

Sales

I need to find out

how much are the new customers in 2017 and 2018? 

How much are the repeat customers in 2018 from the list of new customers in 2017?

How much are the repeat customers in 2018 overall?

6 Replies
isingh30
Specialist
Specialist

Please share your data.

Thanks.

MK_QSL
MVP
MVP

Do you want to achieve at back end (script) or front end?

Can you provide few lines of sample data to work?

madnanansari
Creator
Creator
Author

pls. find attached data in excel.

madnanansari
Creator
Creator
Author

pls. find attached data in excel.

MK_QSL
MVP
MVP

Can you also provide output you are looking for in Excel?

This will make our job easy to help.

madnanansari
Creator
Creator
Author

Output is simple.

it should show the new customer count and repeat customer count.