topic Re: Setting up a 60 day flag - System MonitorLoad in QlikView

Setting up a 60 day flag - System MonitorLoad

Mon, 30 Jun 2014 14:34:14 GMT

I have a field in an application to which I need to add a FLAG (1/0) that checks is a Session Date is less or greater than 60 days since the last access.

The rule for the flag is if(Session_Date) >= 60 than Flag = 1 and if(Session_Date) <60 than Flag = 1.

My Session_Date is declared as -
MakeDate(Year([Session Start]),Month([Session Start]),Day([Session Start])) AS Session_Date

Thanks

Re: Setting up a 60 day flag - System MonitorLoad

maxgro — Mon, 30 Jun 2014 14:57:41 GMT

// maybe you have to swap 0 and 1

if( [Session Start] > (Today(0)-60) and [Session Start] < (Today(0)+60),1,0) as FlagDate,

Re: Setting up a 60 day flag - System MonitorLoad

Tue, 01 Jul 2014 10:30:49 GMT

Thanks that flag seems to give a 60 day flag of user access