Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ankitaag
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
dineshsingh
Partner
Partner

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;

View solution in original post

5 Replies
dineshsingh
Partner
Partner

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;

View solution in original post

ahaahaaha
Partner
Partner

Hi Ankita,

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

Regards,

Andrey

beck_bakytbek
Master
Master

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

ankitaag
Partner
Partner
Author

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
Master
Master

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