topic Re: How exclude null in QlikView

How exclude null

pgalvezt — Tue, 17 May 2016 18:43:30 GMT

Hello,

How can exclude null values from calculated field?

Right(If( Left(Field,1) = 'M', Field),1) as Result

This Form Has null Values and I want to remove them.

Thanks!!

trdandamudi — Tue, 17 May 2016 18:45:20 GMT

check "Suppress when Value is null" under the dimension tab..

sunny_talwar — Tue, 17 May 2016 18:45:46 GMT

So you want to remove Null from your new Column Result? Or are you looking to assign another value to Field when it is Null?

swuehl — Tue, 17 May 2016 18:48:51 GMT

Maybe something like

LOAD *

WHERE LEN(TRIM(Result));

LOAD

Right(If( Left(Field,1) = 'M', Field),1) as Result

FROM YourTableSource;

LOAD *

WHERE NOT ISNULL(Result);

LOAD

Right(If( Left(Field,1) = 'M', Field),1) as Result

FROM YourTableSource;

maxgro — Tue, 17 May 2016 19:19:10 GMT

load

.....,

Right(If( Left(Field,1) = 'M', Field),1) as Result,

.....

from

.....

Where Left(Field,1) = 'M';

MarcoWedel — Tue, 17 May 2016 19:49:17 GMT

Hi,

just one remark:

some other way to test the initial letter being 'M' besides

Left(Field,1) = 'M'

could be:

Field like 'M*'

hope this helps

regards

Marco