Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

Removing Null Value in the Script

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?

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

You can add a where clause to the load statement:

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

HIC

View solution in original post

7 Replies
hic
Former Employee
Former Employee

You can add a where clause to the load statement:

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

HIC

vipin_mishra479
Creator II
Creator II

Hi,

use

where

len(field)>0

Not applicable

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

er_mohit
Master II
Master II

in if condition write this way

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

samuel_brierley
Creator
Creator
Author

Thanks Guys youve all been a massive help

Not applicable

Use this

len(field)>0

kiranmanoharrode
Creator III
Creator III

Dear Samuel,

Use following Where condition it works.

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

Where IsNull(Field)=0;

Regards,

Kiran Rode    

+91 897 6977897