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

In the script do as below:

If(Len(Trim([Deal Type])) > 0,[Dea Type]) as [Deal Type]

Highlighted
Master
Master

i want to write in where condition   i dont want alter the column

is there any way?

Highlighted
Master II
Master II

Something like below:

First:
Load  *
Resident Data
Where Len(Trim(Type)) > 0;

Master
Master

am getting  0,-1 in listbox i used above expression in script.

Highlighted
Master II
Master II

Did you used the If() condition as below:

If(Len(Trim([Deal Type])) > 0,[Dea Type]) as [Deal Type]

Highlighted
Master
Master

its working  but.  one question

if i want write with sql  condition how can i achieve this?

like

sql   filed1

field2

Deal_Type 

where is not null             like this how can i do ?

Highlighted
Master
Master

i used this   but still i can see one blank in listbox  what is the wrong here?

where Deal_Type is not null and Deal_Type <>'' and Deal_Type <>'?';

Highlighted
Champion III
Champion III

Did you try like

WHERE Len(Deal_Type) > 0

Highlighted
Partner
Partner

Is it MS SQL database?

There may be spaces here. You need to do a trim function in SQL where clause.