topic Re: Removing Null Value in the Script in QlikView

Removing Null Value in the Script

samuel_brierley — Wed, 15 Jan 2014 09:10:40 GMT

Hi im pulling data from an excel spreadsheet. the columns have a =if(cell="","",cell) which when loaded into qlikview produces null values. is there a way to remove these in the script?

Re: Removing Null Value in the Script

hic — Wed, 15 Jan 2014 09:41:06 GMT

You can add a where clause to the load statement:

Load ... From File.xls (biff, ...) Where Len(Trim(Field)) > 0 ;

HIC

Re: Removing Null Value in the Script

vipin_mishra479 — Wed, 15 Jan 2014 09:53:56 GMT

Hi,

use

where

len(field)>0

Re: Removing Null Value in the Script

Wed, 15 Jan 2014 10:04:06 GMT

if(Len(Trim(Field)) > 0,cell,' ')

Re: Removing Null Value in the Script

er_mohit — Wed, 15 Jan 2014 10:04:20 GMT

in if condition write this way

if(Len(Trim(cell)) > 0,cell) as CellField

Re: Removing Null Value in the Script

samuel_brierley — Wed, 15 Jan 2014 10:23:28 GMT

Thanks Guys youve all been a massive help

Re: Removing Null Value in the Script

Wed, 15 Jan 2014 11:26:13 GMT

Use this

len(field)>0

Re: Removing Null Value in the Script

kiranmanoharrode — Wed, 15 Jan 2014 11:28:42 GMT

Dear Samuel,

Use following Where condition it works.

From................................

Where IsNull(Field)=0;

Regards,

Kiran Rode

+91 897 6977897