Null Handling

[#1]

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.

[tamilarasu]

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.

[Anonymous]

Did you check this?

NULL handling in QlikView

QlikView Addict: Handling Nulls in QlikView

[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]

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 …