Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

Nulls from DB

Hi all,

i am getting nulls from Database only

but i want to exclude nulls from DB while loading itself  how can i do this in script?  you can see in image with empty spaces i  dont want that

Thanks

Sonyempty.PNG

11 Replies
Highlighted
Master II
Master II

Give a try as below:

WHERE Len(Trim(Deal_Type)) > 0

Highlighted
Partner
Partner

Hi,

you can use also:

Load

...

From/Resident

Where not isnull(Field);