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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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])