topic Re: Select excluded values in a listbox based on selection in other listbox in QlikView

Select excluded values in a listbox based on selection in other listbox

kinjal1645 — Fri, 23 Mar 2018 18:14:33 GMT

Hi,

When I select value in ListBox1, I want similar value/s to be selected in ListBox2.

Currently, value in listbox2 are getting excluded and I want to force selections between. Tried it with trigger, but did not help.

Can someone tell me how can I do it with set analyis or any other way.

Current situation:

ListBox1

Test1.2

Test2.3

Test3.2

Test4.3

ListBox2

Test1.1

Test2.2

Test3.1

Test4.2

Test5.5

Test3.3

Expected: example - Test3.2 should select Test3.1/Test3.3

ListBox1

Test1.2

Test2.3

Test3.2

Test4.3

ListBox2

Test1.1

Test2.2

Test3.1

Test4.2

Test5.5

Test3.3

And it should work other way, selecting Test3.1/Test3.3 should auto-select Test3.2 too.

Kindly help!

Thanks

Re: Select excluded values in a listbox based on selection in other listbox

settu_periasamy — Fri, 23 Mar 2018 18:31:52 GMT

How these two fields are associated? Same table?

Did you try with alternate state?

Re: Select excluded values in a listbox based on selection in other listbox

MarcoWedel — Fri, 23 Mar 2018 18:33:01 GMT

Why would you like excluded values to be selected?

Can you describe the expected behaviour of your application?

Re: Select excluded values in a listbox based on selection in other listbox

kinjal1645 — Fri, 23 Mar 2018 18:41:51 GMT

They are in different table associated with common column.

Re: Select excluded values in a listbox based on selection in other listbox

settu_periasamy — Fri, 23 Mar 2018 19:01:04 GMT

If it is related, it will automatically display. If you want to do it in force, you need to do the trigger with select in field(Listbox2) , search string should be =left(Listbox1, 5)&'*'

And clear the Listbox1

Re: Select excluded values in a listbox based on selection in other listbox

kinjal1645 — Fri, 23 Mar 2018 19:10:33 GMT

I has already tried it with trigger but values are excluded so it did not work. It is working for values that are not excluded with trigger.

Do you know how to do it with 'if' statement or set analysis?