# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor

## Count if null

Hi

I would like count variable3 if:

• Variable1 is NULL
• Variable2 is NOT null
• Variable3 is NOT null

I write this formula, but it does not work:

• Count({<variable3-={0}, varaible2-={0}, variable1=0>} variable3)

Thanks a lot!

D

Labels (1)
• ### Null

1 Solution

Accepted Solutions
Creator III

probably this

count (if(not isnull(variable3) and not isnull(Variable2) and isnull(variable1),variable3))

3 Replies

can you develop your post or share a sample data ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Contributor
Author

Thanks

I want to count "Etapa3" if

1. "Etapa3" is not null.
2. "Etapa2" is null.
3. "Etapa1" is not null

If we take a look over my example (bellow), the result is 3.

Thans a lot!

D

 etapa 1 etapa2 etapa3 2/1/19 7:32 9/4/19 8:33 9/1/19 6:18 10/1/19 6:18 11/1/19 6:18 8/1/19 6:19 8/1/19 6:19 8/1/19 6:18 2/1/19 14:32 10/1/19 7:07 8/1/19 6:21 8/1/19 6:20 8/1/19 6:20 8/1/19 6:20 8/1/19 6:19 8/1/19 6:19 11/1/19 8:50 8/1/19 6:20 14/1/19 8:58 4/3/19 10:31 8/1/19 12:17 27/1/19 12:13 15/1/19 11:58 13/2/19 17:23 14/1/19 9:43 30/1/19 8:47 5/3/19 20:08 11/1/19 8:55 31/3/19 11:44
Creator III

probably this

count (if(not isnull(variable3) and not isnull(Variable2) and isnull(variable1),variable3))

Tags
Community Browser