Discussion board where members can get started with QlikView.
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
In the script do as below:
If(Len(Trim([Deal Type])) > 0,[Dea Type]) as [Deal Type]
i want to write in where condition i dont want alter the column
is there any way?
Something like below:
First: Load * Resident Data Where Len(Trim(Type)) > 0;
am getting 0,-1 in listbox i used above expression in script.
Did you used the If() condition as below:
its working but. one question
if i want write with sql condition how can i achieve this?
where is not null like this how can i do ?
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 <>'?';
Did you try like
WHERE Len(Deal_Type) > 0
Is it MS SQL database?
There may be spaces here. You need to do a trim function in SQL where clause.