show when 2 or 3 conditions are not null

[Anonymous]

I have a table

and I would like to show only rows where 2 or 3 of the columns are not null (in other words to exclude rows with 2 or more null)

so expecting to see:

Any nice way of achieving this?

Raphael

[sergio0592 · Accepted solution]

Hi,

I can't open your document because i'am on personnal edition right now.

But i have create a small sample (four first rows of your example).

So, use in your load statement the flag wchich count the number of missing value:

RangeSum(if(Condition1='',1),if(Condition2='',1), if(Condition3='',1)) as flag

And in your chart, filter the dimension with :

=if(flag=1 or flag=0,Letter,'')

Regards

[Anonymous]

Thanks

[sunny_talwar]

You can also do this in the front end

=If(RangeSum(If(Len(Trim(Cond1)) = 0, 1), If(Len(Trim(Cond2)) = 0, 1), If(Len(Trim(Cond3)) = 0, 1)) < 2, Cond1)

=If(RangeSum(If(Len(Trim(Cond1)) = 0, 1), If(Len(Trim(Cond2)) = 0, 1), If(Len(Trim(Cond3)) = 0, 1)) < 2, Cond2)

=If(RangeSum(If(Len(Trim(Cond1)) = 0, 1), If(Len(Trim(Cond2)) = 0, 1), If(Len(Trim(Cond3)) = 0, 1)) < 2, Cond3)

[Anonymous]

Thank you Sunny.

At the end I did:

=if(isnull(Cond1)+isnull(Cond2)+isnull(Cond3)>=-1,Cond1)

=if(isnull(Cond1)+isnull(Cond2)+isnull(Cond3)>=-1,Cond2)

=if(isnull(Cond1)+isnull(Cond2)+isnull(Cond3)>=-1,Cond3)