Discussion board where members can get started with QlikView.
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 !
Below are the solutions that worked for this situation :
Created a flag using
load Month, Customer, if(Previous(Customer)=Customer,'Old','New') ascc resident table OrderbyCustomer,Month; and straight table dimension
Exp1- =count(DISTINCT Customer)
View solution in original post
You can use Left Join with addmonths(*, 1) for such tasks:
All that is null is a new customer.