topic Re: Identify new customer sales in QlikView

Identify new customer sales

shamitshah — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Please see attached sample file.

How can I identify new customer sales by month over month and year over year?

For example when comparing month over month - in April 2016 both customer B and C would be classified as new as they did not have any sales in the prior month.

When comparing year over year customer F and G would be classified as new in Year 2016 as they did not have any sales in 2015.

Any ideas?

Thanks

Re: Identify new customer sales

swuehl — Fri, 27 Jan 2017 08:49:29 GMT

Have a look at

New customer analysis using set analysis

Re: Identify new customer sales

vinieme12 — Fri, 27 Jan 2017 08:56:10 GMT

Another thing you could do is load a table with CutomerID,Min(TransactionDate) as FirstTransactionDate

You can now use set analysis using greater than or less than on the FirstTransactionDate field

Re: Identify new customer sales

vinieme12 — Fri, 27 Jan 2017 09:07:45 GMT

See Attached app

Re: Identify new customer sales

shamitshah — Sat, 28 Jan 2017 02:02:51 GMT

Thanks Stefan,

That worked out quite well.

Re: Identify new customer sales

shamitshah — Sat, 28 Jan 2017 02:03:20 GMT

Thanks Vineeth