Discussion board where members can get started with QlikView.
I'm using QlikView against an Oracle database, and I'm trying to load data from a table.
I have this code so far:
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?
I have found the solution. I used the function
isnull("END_ACTIVE_DATE" and that worked....