i have a year list box and i selected 2010 ,2011 ,2012 by led check boxes i want find the max of year in my current selection
Where you want to show Maximum ?
it will show only the highest year in the year field but i want highest year in my current selections. in Year list box i have taken led check box so i can select multiple years . now i want to find the max year in my selection.
i have 1 to 10 yrs in list box, but i selected 1 ,4, 6, 7 by multiple selection now i want to show the max value of my selections (7)
Can you try like this?
i have selected 2014 so it will shows 2014 but if i select 2014 and 2015 it will shows '-' so plz suggest
Don't require anything here, Use Max(Year) and select 2/3 then check how Text box returns, And for your condition you may need this
=If(GetFieldSelections(Year) = Max(TOTAL Year), Year)
Max(YearField) should show you what you want, the highest value in your selection.
You may use GetSelectedCount( YearField ) to check if something has been selected at all, to handle all values being possible, not selected.
=If(GetSelectedCount( YearField ), Max(YearField ))
If All field values you had selected in single filed then simply use.
Please review your open threads and close those who received correct answers:
Qlik Community Tip: Marking Replies as Correct or Helpful
Retrieving data ...