topic Re: Get maximum selection in list box in QlikView

Get maximum selection in list box

praveenkumar_s — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Get maximum selection in list box

YoussefBelloum — Wed, 13 Dec 2017 15:05:14 GMT

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

Re: Get maximum selection in list box

praveenkumar_s — Wed, 13 Dec 2017 15:22:54 GMT

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.

Re: Get maximum selection in list box

YoussefBelloum — Wed, 13 Dec 2017 15:29:27 GMT

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

Re: Get maximum selection in list box

datagrrl — Wed, 13 Dec 2017 15:31:49 GMT

Maybe something like this?

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

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

Re: Get maximum selection in list box

praveenkumar_s — Wed, 13 Dec 2017 15:40:24 GMT

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

Re: Get maximum selection in list box

datagrrl — Wed, 13 Dec 2017 15:43:41 GMT

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.

Re: Get maximum selection in list box

praveenkumar_s — Wed, 13 Dec 2017 15:53:27 GMT

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.

Re: Get maximum selection in list box

praveenkumar_s — Wed, 13 Dec 2017 15:54:21 GMT

kindly find the screenshot which i attached in below comments

Re: Get maximum selection in list box

alis2063 — Wed, 13 Dec 2017 18:50:22 GMT

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)

Re: Get maximum selection in list box

praveenkumar_s — Thu, 14 Dec 2017 09:27:41 GMT

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?

Re: Get maximum selection in list box

tresB — Thu, 14 Dec 2017 09:38:26 GMT

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

Re: Get maximum selection in list box

praveenkumar_s — Thu, 14 Dec 2017 09:44:09 GMT

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

Re: Get maximum selection in list box

tresB — Thu, 14 Dec 2017 09:51:24 GMT

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.

Re: Get maximum selection in list box

praveenkumar_s — Thu, 14 Dec 2017 09:56:49 GMT

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

Re: Get maximum selection in list box

tresB — Thu, 14 Dec 2017 10:00:16 GMT

=GetFieldSelections(Field, ',' , 100)

Third parameter is max number of values you can decide.

Re: Get maximum selection in list box

praveenkumar_s — Thu, 14 Dec 2017 10:10:19 GMT

where i need to write this expression?

Re: Get maximum selection in list box

tresB — Thu, 14 Dec 2017 10:16:30 GMT

text box?