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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-01-08 12:08 AM

query

how to pick the list of regionwith Max RSM Code .so that only one RSM email id belong to one rsm for specific region

Preview file
17 KB
310 Views
0 Likes
2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III
‎2016-01-08 12:26 PM

You can use the FirstSortedValue function for this: FirstSortedValue(Region, -RSMCode)


talk is cheap, supply exceeds demand
286 Views
0 Likes
petter
Partner - Champion III
Partner - Champion III
‎2016-01-08 12:32 PM

Two different approaches:

1) via the Load script

2016-01-08 #1.PNG

2) Directly in the UI with expression:

2016-01-08 #2.PNG

Max Email.qvw
286 Views
0 Likes
Community Browser