Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
VishalWaghole
Specialist II
Specialist 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.

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

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

View solution in original post

2 Replies
erichshiino
Partner - Master
Partner - Master

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
Specialist II
Specialist II
Author

Hi Erich,

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