Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
kinjal1645
Contributor

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

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

5 Replies

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

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

Why would you like excluded values to be selected?

Can you describe the expected behaviour of your application?

kinjal1645
Contributor

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

They are in different table associated with common column.

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

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

kinjal1645
Contributor

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

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?