topic Identify new Customers for Current Month in QlikView

Identify new Customers for Current Month

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

Hi All,

Below is the scenario:

I need to identify new customers for the selected current month , comparing them with the values of previous month.

eg: if 01/01/2018 has customers - a1,a2 and month=01/02/2018 has customers- a2,a3 .

if i select month=feb , the new customer name i.e a3 should be displayed in straight table.

Thank You in advance !

Sergey_Shuklin — Thu, 06 Sep 2018 06:47:47 GMT

Hello!

You can use Left Join with addmonths(*, 1) for such tasks:

All that is null is a new customer.

amruta_j — Thu, 06 Sep 2018 08:06:48 GMT

Below are the solutions that worked for this situation :

Backend:

Created a flag using

load
Month,
Customer,
if(Previous(Customer)=Customer,'Old','New') ascc
resident table
OrderbyCustomer,Month;

and straight table dimension

=if(cc='New',Customer)

FrontEnd:

Dim=if(not isnull(Month),Customer)

Exp1- =count(DISTINCT Customer)

Exp2-=if(Count({<Month={'<$(=max(Month))'},Customer=P({<Customer>})>}Customer)>0,'No','Yes')