topic Re: Mandatory Multi Select list box in QlikView

Mandatory Multi Select list box

Anonymous — Tue, 25 Jul 2017 05:58:42 GMT

Hi Gurus..is there any to make a list box is mandatory for at least one value instead of always one selected value..so that i can facilitate more than one value can be selected or minimum one value has to be selected.

Example: I have Month list box, my requirement is users must select atleast one value in Month and also they should be able to select multiple months.

Please share some workarounds.

Br,

Chinna

Re: Mandatory Multi Select list box

Anil_Babu_Samineni — Tue, 25 Jul 2017 06:02:51 GMT

There is no prerequisite to check the box. If possible try to enable LED. Image for ref from presentation tab?

Re: Mandatory Multi Select list box

Anonymous — Tue, 25 Jul 2017 06:06:21 GMT

Hi Anil,

By making the representation as checkbox won't help , If I wanted to do multiselect when I enable Always one selected value checkbox.

Br,

Chinna

Re: Mandatory Multi Select list box

Anil_Babu_Samineni — Tue, 25 Jul 2017 06:14:13 GMT

there is no default option to achieve this? And i would also recommend to read this How to clear the Always One selected value (Mainly Macro)

Re: Mandatory Multi Select list box

neha_shirsath — Tue, 25 Jul 2017 06:43:06 GMT

Hi Chinna,

By using Always one selected value you won't achieve multiple selection if you want to avoid using macro.

You can do unchecked Always one selected value and write trigger on Active sheet select current month by default.

then you can select multiple month also and by default you will get one month selection.

Thanks,

Neha

Re: Mandatory Multi Select list box

Anonymous — Tue, 25 Jul 2017 07:27:23 GMT

Dear Neha,

Above one is already in place. however, our page has clear all button . And some times users are clicking on clear all is clearing the month selection. So I have put additional action on top clear all to select current month.

Now only problem is when they double click on selected month it is getting cleared.

Br,

Chinna

Re: Mandatory Multi Select list box

neha_shirsath — Tue, 25 Jul 2017 07:38:51 GMT

Hi,

For clear all if you have created Clear all button then in Action don't add Clear all action rather than add Clear Other fields and and give Month field then Other than Month field all field will be clear.

Find the attached file for your reference.

Thanks.