Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Get maximum selection in list box

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.

17 Replies
Highlighted
Creator II
Creator II

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?

Highlighted
MVP
MVP

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

Highlighted
Creator II
Creator II

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

Highlighted
MVP
MVP

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.

Untitled.png

View solution in original post

Highlighted
Creator II
Creator II

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

Highlighted
MVP
MVP

=GetFieldSelections(Field, ',' , 100)

Third parameter is max number of values you can decide.

Highlighted
Creator II
Creator II

where i need to write this expression?

Highlighted
MVP
MVP

text box?