topic Re: Automatically select default value in listbox when selecting value in other listbox. in QlikView

Automatically select default value in listbox when selecting value in other listbox.

Tue, 18 Aug 2015 10:25:01 GMT

My question is kind of a complicated one to explain.

I have two listboxes; ShopId and PosId. a ShopId is unique, but a PosId isn't. Example population:

ShopId | PosId

1 | 1

1 | 2

2 | 1

3 | 1

There always has to be one and only one value selected in both listboxes ( PosId and ShopId).

My problem now is that when i select ShopId=1 and PosId=2, i can't click on ShopId=3 because ShopId3 doesn't have a PosId2.

I basically want to change my PosId to the lowest possible value when i select another shop (So that there will always be a selected value in both lisboxes).

If something is still unclear, please ask.

Re: Automatically select default value in listbox when selecting value in other listbox.

Gysbert_Wassenaar — Wed, 19 Aug 2015 12:11:02 GMT

I don't understand why you can't click on ShopId 3. That should be possible. It should simply clear the PosId field, but there's no reason that I know of that wouldn't allow you to select ShopId 3. Can you post a small qlikview document that demonstrates this problem?

Re: Automatically select default value in listbox when selecting value in other listbox.

vikasmahajan — Wed, 19 Aug 2015 12:32:52 GMT

Check with this I think you can go with alternate states https://community.qlik.com/message/787428#787428

Vikas

Re: Automatically select default value in listbox when selecting value in other listbox.

Wed, 19 Aug 2015 14:32:05 GMT

I can indeed click on the other ShopId3 when i have the option ' always have one selected value' off. But i need that option to be 'on' in both listboxes.

To be clear: i ALWAYS want a value selected in both listboxes. I think the most simple way to do that is by setting PosID to 1 whenever another ShopId is selected, but i have no idea how i can do that.

Re: Automatically select default value in listbox when selecting value in other listbox.

Wed, 19 Aug 2015 14:33:05 GMT

I am not sure how i would use that. Can you give me more information?

Re: Automatically select default value in listbox when selecting value in other listbox.

Gysbert_Wassenaar — Wed, 19 Aug 2015 16:49:57 GMT

Add a Select in Field action to the field trigger to make a selection in the other field.

Re: Automatically select default value in listbox when selecting value in other listbox.

Thu, 20 Aug 2015 06:57:02 GMT

I tried doing exactly that, but can you tell me how exactly? I tried a trigger on ShopId select in field (field PosId) with search string 'min(PosId)'

I got it working as said above. but the problem is that i can still uncheck PosId and ShopId because i do not have the option 'always have one selected value' on. I don't want that to happen.

Re: Automatically select default value in listbox when selecting value in other listbox.

Gysbert_Wassenaar — Thu, 20 Aug 2015 16:06:47 GMT

but the problem is that i can still uncheck PosId and ShopId

I'm afraid you've lost me. You will always be able to undo a selection. I don't understand the requirement to not be able to do that and I don't know of any way to achieve that.

Re: Automatically select default value in listbox when selecting value in other listbox.

Fri, 21 Aug 2015 07:41:39 GMT

you said "You will always be able to undo a selection.". That is exactly what i don't want. I need to have 1 Shop and 1 Pos selected at ANY time.

Re: Automatically select default value in listbox when selecting value in other listbox.

Gysbert_Wassenaar — Fri, 21 Aug 2015 14:31:40 GMT

If you don't want a user to be able to make a selection then don't load data with any other values than those you want selected. In other words, hard-code your selection in the script with a where clause.