topic Re: Please help on handling nulls in QlikView

Please help on handling nulls

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

Hi Experts,

I am having 2 fields in table. how to achieve the ouput as it should remove the values if both fields has 0

Input Table:

Output:

kenphamvn — Thu, 18 Jan 2018 07:14:10 GMT

Using where condition when load table

Load
FieldA,FieldB
Resident TABLE_NAME
WHERE FieldA <>0 and FieldB <>0;

if FieldA, FieldB =Null

Using Len(FieldA) <>0 or Len(FieldB) <>0

Regards,

An Pham

siddharth_s3 — Thu, 18 Jan 2018 07:16:05 GMT

LOAD

Field A,

Field B

FROM LIB:\\ExcelFile

WHERE IF(FieldA = 0 AND FieldB = 0 ,1,0) =0

Anonymous — Thu, 18 Jan 2018 07:21:55 GMT

Hi Pham,

Thanks for your reply, I am not getting as expected by where condition.

Is any other way to do this?

Anonymous — Thu, 18 Jan 2018 07:32:21 GMT

Hi Siddharth,

Thanks for your reply. But its not working for me.