Discussion Board for collaboration on QlikView Scripting.
I have data with two date columns (DATE_A, DATE_B).
I need to flag records, which brakes a month (at least one month end between those two dates).
Go to Solution.
You can use this logic to flag them.
=if(Date2 >= MonthEnd(Date1),1,0)
Could you please explain with more details what you need?
if(DATE_A - DATE_B >=30, 1, 0) as Flag
Try like this
if(Fabs(DATE_A - DATE_B) >=30, 1, 0) as Flag
if(MonthName(DATE_A) <> MonthName(DATE_B), 1, 0) as Flag
Hope this helps you.
by using the set anlaysis it implemented
Another one could be:
If(Floor(MonthEnd(DATE_B)) > Floor(MonthEnd(DATE_A)), 1, 0) as Flag;
LOAD * Inline [