topic Overdue actions vs script in QlikView

Overdue actions vs script

jeroenlansberge — Tue, 05 Jun 2018 14:40:04 GMT

Hi there,

I have the following question. I have a list of actions of which some have a due date and others dont.

Now I managed to get it working with below mentioned script, the problem is that where there is no due date he also gives 'overdue', which makes sense but not sure what and how to add a "if there is no due date mention 'x'" function.

Thanks for any support on this!

Example:

Overdue:

Load

Action_Date_Due,

if(Today() > [Action_Date_Due], 'Overdue', 'OnTime') as [Action_Overdue]

Resident Actions3;

Re: Overdue actions vs script

Miguel_Angel_Baeyens — Tue, 05 Jun 2018 14:44:11 GMT

How about?

If(Len(Trim([Action_Date_Due])) > 0, If(Today() > [Action_Date_Due], 'Overdue', 'OnTime'), 'N/A') as [Action_Overdue]

Re: Overdue actions vs script

jeroenlansberge — Tue, 05 Jun 2018 14:54:52 GMT

Hi Miquel,

Yes, it works! thanks for your support, very much appreciated!!