topic Re: Default selection on listbox on selection in other listbox in QlikView

Default selection on listbox on selection in other listbox

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

Hello Experts,

Suppose I load following table

Country	Population
India	20
China	30
UK	40
US	50
India	60

Now I have two list boxes 'Country' and 'Population'.

Requirement:

If I select Country 'India' then two associated values in Population should be green by default.

This should happen to all the values in Country.

How to do this?

Note: I am working on Personal edition so QVWs won't work for me.

Thanks in advance.

Re: Default selection on listbox on selection in other listbox

Anil_Babu_Samineni — Mon, 26 Sep 2016 15:55:36 GMT

Load * Inline [

Country, Population

India, 20

China, 30

UK, 40

US, 50

India, 60

];

Create two list boxes then Select India from Country and see how associative will happen

Re: Default selection on listbox on selection in other listbox

sunny_talwar — Mon, 26 Sep 2016 16:37:24 GMT

You can use triggers to get this done

Select in field Trigger for Population field with the following search string

'(' & Concat(DISTINCT Chr(34) & Population & Chr(34), '|') & ')'

Re: Default selection on listbox on selection in other listbox

nachiket_shinde — Thu, 29 Sep 2016 06:06:19 GMT

Hi Sunny,

I have created the trigger but result is not as expected.

My output should look like

Re: Default selection on listbox on selection in other listbox

sunny_talwar — Thu, 29 Sep 2016 15:33:15 GMT

1) I don't see the field name you are triggering to -> Population here.

2) I think you are missing an equal sign before the expression I gave you

='(' & Concat(DISTINCT Chr(34) & Population & Chr(34), '|') & ')'

Re: Default selection on listbox on selection in other listbox

settu_periasamy — Thu, 29 Sep 2016 15:43:22 GMT

Try this also..

Document Properties -> Field Event Trigger -> Add Actions ->

1. Clear Field - > Population

2. Select Possible -> Population

Re: Default selection on listbox on selection in other listbox

nachiket_shinde — Mon, 03 Oct 2016 10:10:19 GMT

Its not working

Re: Default selection on listbox on selection in other listbox

nachiket_shinde — Mon, 03 Oct 2016 10:11:08 GMT

Hi Settu,

Its not working.

Re: Default selection on listbox on selection in other listbox

sunny_talwar — Mon, 03 Oct 2016 17:27:54 GMT

Is is possible to share the qvw you are working with?

Re: Default selection on listbox on selection in other listbox

nachiket_shinde — Tue, 04 Oct 2016 06:29:49 GMT

Hi Sunny,

Please find file attached.

Re: Default selection on listbox on selection in other listbox

sunny_talwar — Tue, 04 Oct 2016 15:28:15 GMT

I think you were adding a trigger to Population field, when in fact you needed to add one to the Country field.

I added two actions

1) Clear Field -> Population

2) Select in Field -> Population

Search String -> ='(' & Concat(DISTINCT Chr(34) & Population & Chr(34), '|') & ')'

Re: Default selection on listbox on selection in other listbox

nachiket_shinde — Tue, 04 Oct 2016 17:20:48 GMT

Sunny,

Its working fine for first selection. But if I try to change selection it is giving strange results.

It sometime shows associative values or sometimes it selects previous result.

Before selecting any other value in country field I have to clear fields.

Re: Default selection on listbox on selection in other listbox

sunny_talwar — Tue, 04 Oct 2016 18:00:54 GMT

settu_periasamy‌'s suggestion is working perfectly. PFA

Re: Default selection on listbox on selection in other listbox

nachiket_shinde — Wed, 05 Oct 2016 06:57:31 GMT

Yes Sunny,

Its working correctly. I must have made some mistake in implementing.

Thanks for your efforts.

Re: Default selection on listbox on selection in other listbox

sunny_talwar — Wed, 05 Oct 2016 15:50:35 GMT

I am glad you ultimately found the solution you were looking for.

Best,

Sunny