Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Null Handling

Hi,

I have extracted Data from Hbase through Amazon EMR Hbase ODBC driver. I can load tables into Qlikview.

But the problem is the columns which are NULL in Hbase are loaded with default 0 . Can any one suggest the solution to load database

NULL as NULL in qlikview?

My main issue is, some of the columns have 0 as values and I want to differentiate from NULL and 0.

5 Replies
tamilarasu
Champion
Champion

Hi,

Try like below,

If(Len(Trim(FieldName))=0,'',FieldName) as Test

ramasaisaksoft

Hi Hemanth,

i hope you need to control source file only but as per your post u don't have that option

second thing you need to filter data using by  "Resident Load" on conditional basis.

its_anandrjs

Hi,

To remove the NULLs of Flag the NULLs in the load script try some of this ways

1. Isnull() function for identify the null values Ex:- If (isnull(FieldName) = -1 ,1,0) as NullFlag

2. Len(FieldName) = 0 for identifying null values.

Regards,

Anand

nagireddy_qv
Creator II
Creator II

Hi,

There are a couple of ways that you can assign values to NULLs to make these visible. First, if you load data from ODBC and want to display these, you can use the QlikView variable NullDisplay:

Set NullDisplay = '';

or try the below:

Load If( Len( Trim( Field ) ) > 0, Field, '$(NullValue)' ) as NewField …