Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
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