Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
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.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Get maximum selection in list box

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

17 Replies
Highlighted
Champion
Champion

Re: Get maximum selection in list box

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

Highlighted
Creator II
Creator II

Re: Get maximum selection in list box

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.

Highlighted
Champion
Champion

Re: Get maximum selection in list box

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

Creator III
Creator III

Re: Get maximum selection in list box

Maybe something like this?

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

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

Highlighted
Creator II
Creator II

Re: Get maximum selection in list box

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

Highlighted
Creator III
Creator III

Re: Get maximum selection in list box

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.

Highlighted
Creator II
Creator II

Re: Get maximum selection in list box

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.

Sample screenshot.png

Highlighted
Creator II
Creator II

Re: Get maximum selection in list box

kindly find the screenshot which i attached in below comments

Highlighted
Creator II
Creator II

Re: Get maximum selection in list box

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)