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.

[YoussefBelloum]

can you please explain more?

you have list box on which you do multiple selections (jan to mar)

what you want to do in another listbox ??

[praveenkumar_s]

No not in another list box. if i select Jan to march in that list box, charts will show march data only. suppose when a user select May to October in that list box, then charts need to show October data . like wise i need to show maximum month data in charts.

[YoussefBelloum]

I'm sorry i can't follow you,

it is good to attach some screen shots, tell us what kind of objects you use or attach a sample app

[datagrrl]

Maybe something like this?

Sum({<Year = {"$(=Max(Year))"}>} Measure)

Obviously I used Year here, you would switch to your date.

[praveenkumar_s]

yes. but this expression need to be used in chart for maximum selection. But i have to done it in list box itself.

[datagrrl]

Sorry, I really do not understand what you are asking. Maybe if you mocked up what you expected to see.

You said above that you do not need to do it in another list box.

If you want the second list box to only show your selected months, you might want to create a "list box" using a straight table.

[praveenkumar_s]

In the below image you could see that chart show data from Jan to APR. but i want to show only April data without changing the expression inside the chart.

[praveenkumar_s]

kindly find the screenshot which i attached in below comments

[alis2063]

So you you will have to define the expression as below  in  each chart i.e Straight table ,pie,line chart  where you are showing the analysis

Sum({<Year = {"$(=Max(monthnumber))"}>} Measure)