Qlik Community

Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

Highlighted
vishalwaghole
Valued Contributor II

Null Value Problem

Hi guys,

Recentaly i worked on oracle apps database.

In that One table having column name like Authorization_status,

and that column contains values like :- approved, rejected, in process, incomplete with some null values.

Oracle Standard Report convert that Null Values into incomplete state,

But If we want convert this with QlilView Dashbord,

then how its possible...

Thanks

Vishal.

Tags (1)
1 Solution

Accepted Solutions
erich_shiino
Honored Contributor

Re: Null Value Problem

Hi, Vishal.

You can handle it in script.

if your extraction script is like this:

Select ID,App, Authorization_Status  from App_Table;

You can check if the Authorization_status is null:

Load ID, App, if( isnull(Authorization_Status), 'incomplete', Authorization_Status) as Authorization_Status ;

Select ID,App, Authorization_Status  from App_Table;

Hope it helps,

Erich

2 Replies
erich_shiino
Honored Contributor

Re: Null Value Problem

Hi, Vishal.

You can handle it in script.

if your extraction script is like this:

Select ID,App, Authorization_Status  from App_Table;

You can check if the Authorization_status is null:

Load ID, App, if( isnull(Authorization_Status), 'incomplete', Authorization_Status) as Authorization_Status ;

Select ID,App, Authorization_Status  from App_Table;

Hope it helps,

Erich

vishalwaghole
Valued Contributor II

Re: Null Value Problem

Hi Erich,

Its Working, Thanks..............