Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Selecting an emty date in Oracle Table

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

1 Reply
Not applicable

Selecting an emty date in Oracle Table

I have found the solution. I used the function

isnull("END_ACTIVE_DATE" and that worked....

Community Browser