Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

NULL

T:

Load * INLINE [

A,B,C

,1,

2,2,3

,,

];

T2:

Load A,B,C,'' as junk

Resident T

where A<>'' and B<>'' ;

drop table T;

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: NULL

T:

Load

*

INLINE [

A,B,C

,1,

2,2,3

,,

];

T2:

Load

  A,

  B,

  C,

  '' as junk

Resident T

Where not (A=''

and B=''

and C='');

Drop Table T;

5 Replies
Highlighted
Partner
Partner

Re: NULL

T:

Load

*

INLINE [

A,B,C

,1,

2,2,3

,,

];

T2:

Load

  A,

  B,

  C,

  '' as junk

Resident T

Where not (A=''

and B=''

and C='');

Drop Table T;

ahaahaaha
Honored Contributor

Re: NULL

Hi Ankita,

Forgive me, did not understand, but what did you want to receive? Result in the attached file.

Regards,

Andrey

beck_bakytbek
Honored Contributor

Re: NULL

can you explain what do you achieve to expect by that?

Partner
Partner

Re: NULL

Hi,

Apologies for the incomplete question.

I want to ignore the row having all blank values. so as a result i want only 1st and 2nd row.

But the condition where A<>'' and B<>''  and C<>''; doesn't work, however the condition mentioned by Dinesh

not (A='' and B='' and C=''); works. Can anybody explain why?

Thanks and Regards,

Ankita

beck_bakytbek
Honored Contributor

Re: NULL

Hi Ankita,

you can convert the blank value into Zero and alter exclude them

look at this post: https://www.youtube.com/watch?v=l20fjOQgbRc

i hope that helps