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 Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
299 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
275 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
275 Views
0 Likes