Skip to main content

Qlik

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
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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
188 Views
0 Likes
2 Replies
Gysbert_Wassenaar
MVP
MVP
‎2016-01-08 12:26 PM

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


talk is cheap, supply exceeds demand
164 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
164 Views
0 Likes