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
Discover how organizations are unlocking new revenue streams: Watch 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
‎2012-07-04 07:47 AM

GetFieldSelections

Hi, people

i have this func:GetFieldSelections(filed)  and i have an Multiple select and i want to get the higest select.

like: 2010,2011,2012 and get only 2012. (i do it on variables)

Someone know how to do it?

3,594 Views
0 Likes
10 Replies
swuehl
MVP
MVP
‎2012-07-04 11:11 AM

In response to

I don't really get your point.

The suggested

=max(KeyYear)

e.g. in a variable defintion will return the max possible KeyYear (2012 if nothing is selected, or the maximum KeyYear within the selected list of KeyYears).

Just drop the GetFieldSelections() function.

If you only want to get a result when the user has selected at least one KeyYear, define your variable like

=if(GetSelectedCount(KeyYear), max(KeyYear) )

1,541 Views