Discussion board where members can get started with Qlik Sense.
Load * INLINE [
Load A,B,C,'' as junk
where A<>'' and B<>'' ;
drop table T;
Go to Solution.
'' as junk
Where not (A=''
Drop Table T;
Forgive me, did not understand, but what did you want to receive? Result in the attached file.
can you explain what do you achieve to expect by that?
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,
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