Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
aj_954
Contributor III
Contributor III

How to count the unique values for a given conidtion

Hi

I have a following example data:

Label T/F

A          T

A          T

A          T

B          F

B          F

C          T

C         T

 

I want to write a expression for a KSI that shows the *unique* times a the variable "label" gets assigned true. So in this example, it would be 2.

 

1 Solution

Accepted Solutions
aj_954
Contributor III
Contributor III
Author

easy solution:

Count({1<Label={'TRUE'}>} distinct Label)

View solution in original post

1 Reply
aj_954
Contributor III
Contributor III
Author

easy solution:

Count({1<Label={'TRUE'}>} distinct Label)