topic If count condition in load statement in QlikView

If count condition in load statement

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

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

CustID	Date	Flag
1	12/7/2015
2	1/25/2016
3	1/24/2017
4	2/16/2017
6	3/3/2017
7	11/7/2017
2	01/02.2018	Old Customer
9	01/07.2018	New Customer
4	01/11.2018	Old Customer

Re: If count condition in load statement

el_aprendiz111 — Mon, 15 Jan 2018 17:16:57 GMT

Hi,

LOAD *, if(Exists(CustID),'Old Customer','New Customer') AS Flag;
LOAD CustID,
Sales_Date
FROM
Inventry.xlsx
(ooxml, embedded labels, table is Sheet2);

Re: If count condition in load statement

karan_kn — Tue, 16 Jan 2018 10:22:30 GMT

Thanks for your response, also help me to flag old customer by year,

Ex:

OrgID

2 - '< 2 Year'

4 - '< 1 Year'

9 - 'New Customer'

topic If count condition in load statement in QlikView

If count condition in load statement

2

01/02.2018

Old Customer

9

01/07.2018

New Customer

4

01/11.2018

Old Customer

Re: If count condition in load statement

Re: If count condition in load statement