topic Create new flag using existing Flag in QlikView

Create new flag using existing Flag

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

How to create additional flag sum of two flags (Flag1 + New)

Table:

LOAD *,

IF(MonthDiff >= 1 AND MonthDiff <= 36, 'Flag1',
IF(MonthDiff >=37 AND MonthDiff <= 60, 'Flag2','New'))) AS DateFlag

Add one more Flag (Flag1 +'New' = Flag3)

Re: Create new flag using existing Flag

Claudiu_Anghelescu — Mon, 12 Aug 2019 08:30:35 GMT

=IF(MonthDiff <37 AND MonthDiff > 61), 'Flag3') as Flag

Re: Create new flag using existing Flag

anushree1 — Mon, 12 Aug 2019 08:50:39 GMT

Use Preceeding Load , like below:

Table:

Load *,

Flag1 +New as Flag3

LOAD *,

IF(MonthDiff >= 1 AND MonthDiff <= 36, 'Flag1',
IF(MonthDiff >=37 AND MonthDiff <= 60, 'Flag2','New'))) AS DateFlag

From <<.....>>

or Resident Load like:

Temp:

LOAD *,

IF(MonthDiff >= 1 AND MonthDiff <= 36, 'Flag1',
IF(MonthDiff >=37 AND MonthDiff <= 60, 'Flag2','New'))) AS DateFlag

From <<.....>>

Table:

Load *,

Flag1 +New as Flag3

resident Temp;

Drop table Temp;

Hope Flag1 and New are Numerical Entries

Re: Create new flag using existing Flag

karan_kn — Mon, 12 Aug 2019 10:10:14 GMT

Thanks for the response, but the flag getting blank. It's not accepting to merge two values.

Re: Create new flag using existing Flag

anushree1 — Mon, 12 Aug 2019 10:32:40 GMT

can u share the sample file

Re: Create new flag using existing Flag

karan_kn — Mon, 12 Aug 2019 10:53:23 GMT

create new flag Flag3 + New =Flag4

Script:

T1:

LOAD *,

IF(MonthDiff >= 1 AND MonthDiff <= 12, 'Flag1',

IF(MonthDiff >=13 AND MonthDiff <= 36, 'Flag2',

IF(MonthDiff >=37 AND MonthDiff <= 60, 'Flag3','New'))) AS DateFlag

LOAD *,

IF(ISNULL(Max_Sales_Date) = -1, 'Null', ((year(Sales_Date)*12)+month(Sales_Date)) - (((year(Max_Sales_Date)*12)+ month(Max_Sales_Date)))) AS MonthDiff

Resident Temp;

DROP Table Temp;