topic Re: Null Handling in QlikView

Null Handling

Fri, 12 Feb 2016 07:37:45 GMT

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.

Re: Null Handling

tamilarasu — Fri, 12 Feb 2016 07:41:40 GMT

Hi,

Try like below,

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

Re: Null Handling

ramasaisaksoft — Fri, 12 Feb 2016 07:46:09 GMT

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.

Re: Null Handling

Anonymous — Fri, 12 Feb 2016 07:46:14 GMT

Did you check this?

NULL handling in QlikView

QlikView Addict: Handling Nulls in QlikView

Re: Null Handling

its_anandrjs — Fri, 12 Feb 2016 07:53:28 GMT

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

Re: Null Handling

nagireddy_qv — Fri, 12 Feb 2016 17:38:23 GMT

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 …