topic Listbox Selection in QlikView

Listbox Selection

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

Hi All,

I have three listboxes as shown below. when I select a value from New Customer, I want the other two listboxes to select particular values(In_Out = 'Both' and With_Without = 'Without Properties').

My Expected Result:

Also attached my sample QVW.

Re: Listbox Selection

Anil_Babu_Samineni — Wed, 09 Aug 2017 14:04:10 GMT

Looks like there is no associate in front-end and when i see Model it's getting associate using Primary key. May be script Helps us. If you want this in UI then let us know.

Re: Listbox Selection

Anonymous — Wed, 09 Aug 2017 14:10:44 GMT

Thanks Anil. I want to achieve this by anyway, please help.

Re: Listbox Selection

vishsaggi — Wed, 09 Aug 2017 14:16:02 GMT

Why it should be only "Without Properties" and "Both" just wondering to know. The list boxes With_Without and In_Out showing correct possible values for the selected customer.

Coz you have possible data from those two list boxes as show in table box below. Can you explain a little please...?

Re: Listbox Selection

Anonymous — Wed, 09 Aug 2017 14:25:08 GMT

Initially, when I select a value from New customer, I wanted to select these values. After that we need to be able to change.

Re: Listbox Selection

vishsaggi — Wed, 09 Aug 2017 14:28:04 GMT

But that value is associated to both with and without...including all In_Out values as you can see in the table.

Re: Listbox Selection

ahaahaaha — Wed, 09 Aug 2017 14:43:27 GMT

Hi,

May be as variant like at attached file?

Create a bookmark B01 with necessary selections. Create variable vBM with value =If(GetSelectedCount(Customer_EntityName)>0, 1, 0). The variable goes to state 1 if it is selected in "New Customer". In the document properties, define a trigger for changing the variable vBM which uses the previously created bookmark B01 when changing a variable.

Regards,

Andrey

Re: Listbox Selection

marcelviegas — Wed, 09 Aug 2017 18:53:32 GMT

Hi,

Try with a trigger, as shown below: