conditional count

[qlik_user3]

Hi all, I'm new in qlik.

I would like to count how many distinct user, where STATE is not FALSE and DATE is null, there are in the follow table. 

Can you help me please? 

[MayilVahanan]

Hi @qlik_user3 

Try like below

=Count({<STATE-={'FALSE'}, DATE={"=Len(Trim(DATE))=0"}>}DISTINCT USER)

[Taoufiq_Zarra]

@qlik_user3  Maye be :

=count({<STATE={"*"}-{'FALSE'},USER={"=len(trim(DATE))=0"}>} distinct USER)

output:

[qlik_user3]

I'm load an example, I wanto to find distinct user with STATE=IN PROGRESS and DATE=NULL. Maybe I make an error with date values.

Can you try with this file? Thank you 

[Taoufiq_Zarra]

@qlik_user3 

=count({<STATE={'IN PROGRESS'},ID={"=len(trim(DATE))=0"}>} distinct USER)

output:

[qlik_user3 · Accepted solution]

Hi Taoufiq, thank you so much for your answer. I try to do your code but it doesn't work.

I found another way and I have a solution.

There are two pictures, OK is my solution, ERROR it's your solution. Do you think that I make a mistake?

Thank you.