Get maximum selection in list box

[praveenkumar_s]

Friends,

I have a list box consists of 12 month from Jan to Dec. when i multi-select the month like Jan to Mar, other associated objects gets associated for maximum selected month like Mar data. I want to do it in list box itself rather than set expression in all objects.

Please let me know in case of any clarifications.

[praveenkumar_s]

yeah. i understand . but is it any other way like instead of changing in all straight table, pie or line chart. why can't we write any expression in the list box itself?

[tresesco]

One way is - as Ali suggested 'using set analysis'. Another way could be using trigger to set the selection to max month only even if the users try to select multiple months. PFA

[praveenkumar_s]

sorry I'm  having personal edition . can you explain in simple steps so that i can try?

[tresesco · Accepted solution]

See, first I try to select multiple values from month field, but when leave my mouse - it ends up selecting the max value. The later part of screen shot shows how I set the trigger.

[praveenkumar_s]

exactly what i want.thank you so much.is there any way to show all the selection in the list box?

[tresesco]

=GetFieldSelections(Field, ',' , 100)

Third parameter is max number of values you can decide.

[praveenkumar_s]

where i need to write this expression?

[tresesco]

text box?