Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

madnanansari
New Contributor III

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
Contributor III

Re: New & Repeat customers

Please share your data.

Thanks.

Re: New & Repeat customers

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

Can you provide few lines of sample data to work?

madnanansari
New Contributor III

Re: New & Repeat customers

pls. find attached data in excel.

madnanansari
New Contributor III

Re: New & Repeat customers

pls. find attached data in excel.

Re: New & Repeat customers

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

This will make our job easy to help.

madnanansari
New Contributor III

Re: New & Repeat customers

Output is simple.

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