topic Re: Protect multiple selection from list box in QlikView

Protect multiple selection by CTRL key from list box

Mon, 15 Jun 2015 17:38:32 GMT

How can I protect multiple selection from a listbox where user can't select more than 1 record by pressing CTRL key

User can select only 1 country at a time. Anyone can answer.

My question is very simple -

1. No country will be select after reload data

2. After reload when I select "Afghanistan", I can see only the expression against "Afghanistan"

3. If I select "Albania" then "Afghanistan" will be deselect and can see only the expression against "Albania"

4. If I press CTRL key and try to select both country "Afghanistan" and "Albania" then it will not work.

Anyone can give this answer by written not any qvw file?

Re: Protect multiple selection from list box

arthur_dom — Mon, 15 Jun 2015 17:40:48 GMT

only 1 selected at time? No less and no more?

Re: Protect multiple selection from list box

Mon, 15 Jun 2015 17:44:13 GMT

default no country will be select. After select 1, you can't select more.

Re: Protect multiple selection from list box

nagaiank — Mon, 15 Jun 2015 17:55:49 GMT

When no country is selected (default), do you want to see the data for all the countries or no data?

Re: Protect multiple selection from list box

arthur_dom — Mon, 15 Jun 2015 17:57:48 GMT

Attached is 3 options i think can be done on QV. Please see if you find someone useful!

Re: Protect multiple selection from list box

Mon, 15 Jun 2015 18:02:32 GMT

no data. you can't select multiple country by CTRL key.

Re: Protect multiple selection from list box

Mon, 15 Jun 2015 18:05:44 GMT

I have QV personal edition. can you give me doc file.

Re: Protect multiple selection from list box

santhoo_san — Mon, 15 Jun 2015 18:44:55 GMT

Enable Always One Selected Value under General Tab of List box Properties.

Re: Protect multiple selection from list box

jonas_rezende — Mon, 15 Jun 2015 20:02:40 GMT

Hi.

Perform the following steps in the List Box Properties:

1. Right-click in title Country for choose properties;

2. Tab General, localize Hide Excluded checkbox;

3. Click Ok;

4. Test - select with or without Ctrl key.

Hope this help!

Re: Protect multiple selection from list box

Tue, 16 Jun 2015 07:38:06 GMT

Hi Jonas,

Hide Excluded is another thing where you only see selected record.

Re: Protect multiple selection from list box

Tue, 16 Jun 2015 07:45:11 GMT

Hi Santosh,

Enable One Selected Value is partially correct but I need no country will be selected after loading. Here if I enable One Selected Value then always 1 country will be selected default after loading.

Re: Protect multiple selection from list box

santhoo_san — Tue, 16 Jun 2015 08:39:37 GMT

Hi, Please see attached example. Subodh has already addressed this.

roche.subodh

Re: Protect multiple selection by CTRL key from list box

Sat, 20 Jun 2015 17:03:15 GMT

Set up a trigger for a field on an OnSelect event (Settings -> Document Properties -> Triggers). For field FIELD set up Selection -> Select in Field -> use =Only(FIELD) as Search String.