Discussion board where members can get started with QlikView.
When we filtering the current month:
If same ID's are coming multiple time flag as Old customer,
if New IDs are coming flag as New Customer,
using If condition in load statement
LOAD *, if(Exists(CustID),'Old Customer','New Customer') AS Flag; LOAD CustID, Sales_Date FROM Inventry.xlsx (ooxml, embedded labels, table is Sheet2);
Thanks for your response, also help me to flag old customer by year,
2 - '< 2 Year'
4 - '< 1 Year'
9 - 'New Customer'