Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JoseGarcia
Creator III
Creator III

count function

hi there,
need to count items if content equals to 'yes' or 'no' or 'n/a'

could anyone suggest a formula?

currently using: 

Count({<my_element_66={'yes'}, {'no'}, {'n/a'}>}, my_element_66)

any ideas?

Labels (1)
  • Chart

1 Solution

Accepted Solutions
Taoufiq_Zarra

@JoseGarcia 

=Count({<my_element_66={'yes', 'no','n/a'}>} my_element_66)

like :

Taoufiq_Zarra_0-1645104965021.png

 

Regards,
Taoufiq ZARRA

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

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

View solution in original post

2 Replies
Taoufiq_Zarra

@JoseGarcia 

=Count({<my_element_66={'yes', 'no','n/a'}>} my_element_66)

like :

Taoufiq_Zarra_0-1645104965021.png

 

Regards,
Taoufiq ZARRA

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

(you can mark up to 3 "solutions") 😉
JoseGarcia
Creator III
Creator III
Author

@Taoufiq_Zarra thanks a million!