Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Jogi
Contributor III
Contributor III

Set expressions - select text based on measure

Hi all, 

I have table : 

DistanceText
1CityA
2CityB

 

 and I want to create KPI - that should show min(Distance) = CityB

how to do it with set expression? thanks 

Labels (2)
1 Solution

Accepted Solutions
Jogi
Contributor III
Contributor III
Author

Hi, 

solution: 

Only({<[Distance] = {$(=min([Distance]))} >} [Text])

View solution in original post

1 Reply
Jogi
Contributor III
Contributor III
Author

Hi, 

solution: 

Only({<[Distance] = {$(=min([Distance]))} >} [Text])