Hi
I'm using QlikView against an Oracle database, and I'm trying to load data from a table.
I have this code so far:
LOAD *
where "ROLE" = 'Project Executive'
and "START_DATE_ACTIVE" < Today()
and "END_DATE_ACTIVE" >= Today();
SQL SELECT
"PROJECT_ID",
"ROLE",
"END_DATE_ACTIVE",
"START_DATE_ACTIVE",
"FULL_NAME"
as ProjExec
FROM APPS."PA_PROJECT_PLAYERS_V";
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?
Thx
Hans Peter
