topic Re: limit selection in multibox in QlikView

limit selection in multibox

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

i want a user should be able to select max of three values from the multibox

Re: limit selection in multibox

Anil_Babu_Samineni — Thu, 13 Oct 2016 15:32:17 GMT

Why not list box

Re: limit selection in multibox

singbittoo — Thu, 13 Oct 2016 15:34:41 GMT

it is the requirement ,, but if u can tell how to limit selection to max 3 in list box that will also be helpful

Re: limit selection in multibox

vcanale — Thu, 13 Oct 2016 15:48:43 GMT

Hi,
Try to Sort the field on Text or Numerical Value depending on the data
..or Expression also with =Max(fieldname)

Re: limit selection in multibox

singbittoo — Thu, 13 Oct 2016 16:11:28 GMT

sorry not getting what u are saying

Re: limit selection in multibox

Anil_Babu_Samineni — Fri, 14 Oct 2016 02:02:53 GMT

Try Listbox as a Expression and then use this

=If(GetSelectedCount(FieldName)<=3,FieldName)

And then Try to select more than 3 and see, If no values are not Hidden you can create show one message for Text object to user like More than 3 Selections are not effected like that

Hope this Helps

Re: limit selection in multibox

Fri, 14 Oct 2016 10:10:37 GMT

Hi abhishek ,

You could set up a trigger based on the selected count.

Hope the attached file is helpful.

Regards,

Karthik

Re: limit selection in multibox

singbittoo — Sat, 15 Oct 2016 11:29:18 GMT

hi karthik i m sorry i m not getting any attached file can you please explain here

Re: limit selection in multibox

Mon, 17 Oct 2016 04:41:59 GMT

Assume you have a field called 'Name' consisting of five records . Now you would like to limit user's selection to 3 records. Go to Document properties->Triggers->Field event triggers and then choose the field ' Name ' .In the 'On select option ' write the following trigger .(Action=Clear field )

if(GetSelectedCount(Name)>3,'Name')

Regards,

Karthik.

Re: limit selection in multibox

rupamjyotidas — Mon, 17 Oct 2016 19:17:46 GMT

Sometimes requirements are crazy. Why do you want to ruin a simple list box/multi box with equation or triggers, just put a note (in a text box) above saying 'Max of Three values to be selected'. If the Users select more than three values , don't calculate anything, you can use conditional for the same.

But if you want to complicate the apps, you can always use triggers or Equation in the list box.

Re: limit selection in multibox

johnw — Mon, 17 Oct 2016 19:56:04 GMT

Expanding on this, and this is kind of funky, but rather than clearing the field if you select more than three, you can just prevent the change. Change your clear field to be <=3 instead of >3, then add a Back action after.

clear field =if(getselectedcount(Name)<=3,'Name')
back

As long as you've selected 3 or fewer, it clears the field, then does a back, taking you back to your intended selections. If you've selected more than 3, it doesn't clear the field, so when you go back, it removes your most recent selection that took you over the limit.

There's probably a cleaner way to do it, but that's what I thought of.

Re: limit selection in multibox

Anil_Babu_Samineni — Tue, 18 Oct 2016 02:51:03 GMT

Have you tried my solutions

Re: limit selection in multibox

johnw — Tue, 18 Oct 2016 22:44:17 GMT

I'm not the original poster, but I tried it. You can select as many values as you want. But if you select more than three, then afterwards the list box disappears except for the caption, making it very difficult to make any further changes in selections, such as getting back down to 3 or fewer. You need to do something like clear the field before you can use the list box again.

I didn't understand what you were trying to do with the text object, though, so maybe I've completely misunderstood your suggestion.