topic Re: Nulls from DB in QlikView

Nulls from DB

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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

Sony

Re: Nulls from DB

trdandamudi — Wed, 08 Aug 2018 18:48:19 GMT

In the script do as below:

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

Re: Nulls from DB

soniasweety — Wed, 08 Aug 2018 18:51:02 GMT

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

is there any way?

Re: Nulls from DB

trdandamudi — Wed, 08 Aug 2018 18:54:12 GMT

Something like below:

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

Re: Nulls from DB

soniasweety — Wed, 08 Aug 2018 18:54:17 GMT

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

Re: Nulls from DB

trdandamudi — Wed, 08 Aug 2018 18:55:37 GMT

Did you used the If() condition as below:

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

Re: Nulls from DB

soniasweety — Wed, 08 Aug 2018 19:01:26 GMT

its working but. one question

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

sql filed1

field2

Deal_Type

where is not null like this how can i do ?

Re: Nulls from DB

soniasweety — Wed, 08 Aug 2018 19:03:27 GMT

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 <>'?';

Re: Nulls from DB

vishsaggi — Wed, 08 Aug 2018 19:08:32 GMT

Did you try like

WHERE Len(Deal_Type) > 0

Re: Nulls from DB

agrawalpavan — Wed, 08 Aug 2018 19:09:08 GMT

Is it MS SQL database?

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

Re: Nulls from DB

trdandamudi — Wed, 08 Aug 2018 19:11:12 GMT

Give a try as below:

WHERE Len(Trim(Deal_Type)) > 0

Re: Nulls from DB

andrei_delta — Thu, 09 Aug 2018 06:43:37 GMT

Hi,

you can use also:

Load

...

From/Resident

Where not isnull(Field);