Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
CB-CAN
Contributor II
Contributor II

counting distinct field results with specific text

Tring to count the distinct number of runners that have expired from a field list using - count(distinct([Runner]='*EXPIRED*')) but don't get the the expected answer from the below data for which I would hope to get the answer "2"

Using  - count(distinct([Runner]) = "3"

Help appreciated - thanks

RUNNER
JE937_EXPIRED
CE214_EXPIRED
CE214_EXPIRED
JE937_EXPIRED
CE214_EXPIRED
FY785
JE937_EXPIRED
CE214_EXPIRED
JE937_EXPIRED
CE214_EXPIRED
FY785
CE214_EXPIRED
FY785
FY785
CE214_EXPIRED
FY785
CE214_EXPIRED
Labels (3)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

1 Reply
vinieme12
Champion III
Champion III

as below

=count( {<RUNNER={"*EXPIRED"}>}distinct [Runner] ) 

https://community.qlik.com/t5/Design/The-Expression-Search/ba-p/1463907

https://community.qlik.com/t5/Design/The-Search-String/ba-p/1470548

https://community.qlik.com/t5/Design/Quotes-in-Set-Analysis/ba-p/1471824

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.