Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

Give a try as below:

WHERE Len(Trim(Deal_Type)) > 0

Partner
Partner

Hi,

you can use also:

Load

...

From/Resident

Where not isnull(Field);