Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like attached
Hi,
Yo can use,
Sheet Properties -> Trigger,
Select --> Select in Field --> Enter Field Name & Field Value
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.
OK .. Something like this .. ?
IF(GetSelectedCount(FIELD)=0,'XYZ')
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.
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.
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 .
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
May be like attached
You .. are stop on . Salute !