topic Re: how to write two conditions in count() function in QlikView

how to write two conditions in count() function

WorkFish — Mon, 20 Jun 2022 09:20:32 GMT

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 .

Re: how to write two conditions in count() function

Or — Mon, 20 Jun 2022 09:27:29 GMT

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.

Re: how to write two conditions in count() function

WorkFish — Mon, 20 Jun 2022 09:54:22 GMT

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

Re: how to write two conditions in count() function

Or — Mon, 20 Jun 2022 10:50:20 GMT

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

Re: how to write two conditions in count() function

WorkFish — Mon, 20 Jun 2022 11:52:50 GMT

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

Re: how to write two conditions in count() function

Or — Mon, 20 Jun 2022 11:55:24 GMT

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