how to write two conditions in count() function

[WorkFish]

hi guys

    I have a expression like this: count({<FieldA={"valueA"} >}distinct FieldB) and it works,
now i want to add another condition on it but i dont know how to write the expression.

Here's my new expression and it's wrong:count({<FieldA={"valueA"} and FieldB={"Yes"}>}distinct FieldB).

Can anyone tell me how to modify it?
Thanks in advance .

[Or]

count({<FieldA={"valueA"} , FieldB={"Yes"}>}distinct FieldB)

Note that this expression is only ever going to return either 0 or 1, since only "Yes" values will be possible in FieldB.

[WorkFish]

hi @Or 

it's works. but if i want add a condition which is : FieldB is null or len(FieldB)=0 ,how should i write

[Or]

If FieldB is null, Count(FieldB) will be 0, so there's no need to do anything different as the outcome will be identical.

[WorkFish]

Sorry that i made a mistake.

It's count({<FieldA={"valueA"} , FieldB={"Yes"}>}distinct FieldC),the third Field  is C not B.

So the "FieldB is null " how to write it ?

Feel Sorry again

[Or]

https://community.qlik.com/t5/QlikView-App-Dev/Null-value-in-set-analysis/td-p/1221677

https://community.qlik.com/t5/QlikView-App-Dev/Set-Analysis-include-Null-Values-only/td-p/1579255