Qlik Community

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 
Search instead for 
Did you mean: 
DavidMetodoyEmocion
Contributor
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)

Could you please help me?

Thanks a lot!

D

Labels (1)
  • Null

1 Solution

Accepted Solutions
asinha1991
Creator III
Creator III

probably this

 

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

View solution in original post

3 Replies
Taoufiq_Zarra

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") 😉
DavidMetodoyEmocion
Contributor
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 1etapa2etapa3
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:3210/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:1911/1/19 8:50
 8/1/19 6:20 
14/1/19 8:584/3/19 10:31 
8/1/19 12:17 27/1/19 12:13
15/1/19 11:5813/2/19 17:23 
14/1/19 9:43  
30/1/19 8:475/3/19 20:08 
11/1/19 8:55 31/3/19 11:44
asinha1991
Creator III
Creator III

probably this

 

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

View solution in original post