I'm using QlikView against an Oracle database, and I'm trying to load data from a table.
I have this code so far:
where "ROLE" = 'Project Executive'
and "START_DATE_ACTIVE" < Today()
and "END_DATE_ACTIVE" >= Today();
as part of the data load. The problem is that the "END_DATE_ACTIVE" is empty for the current Project Executives or it can be set to a future date.
How do I make an IF statement to handle this situation?