topic Flag dates in load script in QlikView

Flag dates in load script

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

Can someone help me if the condition is not coming under this (1 to 60 months, it must be less than 1 month) how to flag that one?

T1:

LOAD *,

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

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

IF(MonthDiff >=37 AND MonthDiff <= 60, 'Flag3','Flag4'))) AS Status;

sunny_talwar — Mon, 05 Feb 2018 15:36:19 GMT

Isn't Flag4 what you want? It would include anything less than 1 month and greater than 60 months

aarkay29 — Mon, 05 Feb 2018 15:36:48 GMT

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

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

IF(MonthDiff >=37 AND MonthDiff <= 60, 'Flag3',

IF(MonthDiff =0 , 'Flag4')))) AS Status;

the expression that you are using would give Monthdiff<1 or monthdiff >60 for 'Flag4' use this instead

karan_kn — Mon, 05 Feb 2018 15:37:32 GMT

less than 1 month

sunny_talwar — Mon, 05 Feb 2018 15:38:29 GMT

less than 1 month??

are you going to write more than this or that was it