Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

10 Replies
swuehl
MVP
MVP

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) )