topic Re: How to make a multi box select a default value with there is not selection done in that ? in QlikView

How to make a multi box select a default value with there is not selection done in that ?

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

Hi All ,

How to make a multi box select a default value with there is not selection done in that but it should also allow user to select multiple values from multibox .

NOTE : When I am ticking "Always selected one value" , user is not able to select multiple values from Multibox .

Is there any other way to achieve this .

Thanks & Regards

Shekar

Re: How to make a multi box select a default value with there is not selection done in that ?

muthukumar77 — Tue, 14 Mar 2017 09:18:36 GMT

Hi,

Yo can use,

Sheet Properties -> Trigger,

Select --> Select in Field --> Enter Field Name & Field Value

Re: How to make a multi box select a default value with there is not selection done in that ?

Peter_Cammaert — Tue, 14 Mar 2017 09:21:07 GMT

You mean you want a different feature like "one or more items selected"? Maybe you can do this using triggers.

However, a multibox is not a listbox but an assembly of listboxes. Do you mean that any explicit selection anywhere in one of the multibox listboxes will do? And whenever no selection is made, should default values be selected in all listboxes, just in a few, or in a single one?

BTW "no selection" is difficult to handle in QlikView, because usually when you click the Clear button (i.e. no selection) everything is selected.

Re: How to make a multi box select a default value with there is not selection done in that ?

shekhar_analyti — Tue, 14 Mar 2017 09:33:50 GMT

OK .. Something like this .. ?

IF(GetSelectedCount(FIELD)=0,'XYZ')

Re: How to make a multi box select a default value with there is not selection done in that ?

Peter_Cammaert — Tue, 14 Mar 2017 09:42:32 GMT

Exactly.

Add this to a Document Event Trigger of type "OnAnySelect". That way, every change to any listbox or chart will cause the check code to be triggered.

Re: How to make a multi box select a default value with there is not selection done in that ?

devarasu07 — Tue, 14 Mar 2017 09:46:18 GMT

Hi,

Try like below,

Sheet Properties -> Trigger,

Select --> Select in Field --> Enter Field Name & Field Value (by default you can assign multiple values and when you re-open the app it will show default assigned values and u can select multiple values also). make sure to deselect "Always one selected check box"

FYI, attached sample app.

Re: How to make a multi box select a default value with there is not selection done in that ?

shekhar_analyti — Tue, 14 Mar 2017 10:01:48 GMT

But what if user deselects both the values from Product ID .

What i want is that the moment user removes all the selection from PRODUCT ID , system should default it to select Product id 710 in multibox .

Re: How to make a multi box select a default value with there is not selection done in that ?

devarasu07 — Tue, 14 Mar 2017 10:06:51 GMT

Hi Shekar,

But what if user deselects both the values from Product ID .?

if use deselect the default value and then it will show all values as result.

want is that the moment user removes all the selection from PRODUCT ID , system should default it to select Product id 710 in multibox .?

I don't think it's possible. stalwar1‌ can you advise this?

Tks

Deva

Re: How to make a multi box select a default value with there is not selection done in that ?

sunny_talwar — Tue, 14 Mar 2017 10:12:10 GMT

May be like attached

Re: How to make a multi box select a default value with there is not selection done in that ?

shekhar_analyti — Tue, 14 Mar 2017 10:17:26 GMT

You .. are stop on . Salute !

Re: How to make a multi box select a default value with there is not selection done in that ?

sunny_talwar — Tue, 14 Mar 2017 10:18:20 GMT

you mean spot

Re: How to make a multi box select a default value with there is not selection done in that ?

Anonymous — Mon, 18 Dec 2017 14:55:31 GMT

Hi Sunny Talwar,

I'm facing the same issue unfortunately I can't open your file on my work computer.

Could you please explain me the logic ?

Thanks !

Maria

Re: How to make a multi box select a default value with there is not selection done in that ?

sunny_talwar — Mon, 18 Dec 2017 17:16:25 GMT

There is a OnAnySelect trigger in the Document properties with the following Expression

=If(GetSelectedCount(ProductID) = 0, 710, '(' & Concat(DISTINCT ProductID, '|') & ')')

Re: How to make a multi box select a default value with there is not selection done in that ?

Anonymous — Tue, 19 Dec 2017 07:59:34 GMT

Thanks

Re: How to make a multi box select a default value with there is not selection done in that ?

shekhar_analyti — Tue, 19 Dec 2017 08:07:34 GMT

I Marie i will try to explain you by EOD as i do not have access to license version .

Re: How to make a multi box select a default value with there is not selection done in that ?

derekledbetter — Mon, 30 Apr 2018 19:27:01 GMT

I also need to "default" to certain values on the initial loading of the application. Then, if they change it, keep it that way and do not revert back to default. In other words, "first time" access.

I'd appreciate it if an explanation can be provided to me as well.

Thanks in advance.

Derek