Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ProjExecas 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
I have found the solution. I used the function
isnull("END_ACTIVE_DATE" and that worked....