Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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)