Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

siva_boggarapu
Contributor II

Help required

Col1
AAA
BBB
CCC
DDD
EEE

FFF

Col2
AAA
BBB
CCC
DDD
EEE
FFF

Col3

AAA
BBB
CCC
DDD
EEE
FFF

I have three listboxes like above in same table with Different name but data is same. If I select 1st listbox 2nd and 3rd shouldn't select any values. If I select 2nd listbox, both 1st and 2nd should select values and 3 rd shouldn't. Simillarly If 1st,2nd and 3rd select listboxes it should total values in one Textbox. The Selection is always forward direction only.

Any suggestions would be appreciate.

Best,

Siva

9 Replies
perumal_41
Valued Contributor II

Help required

Hi Siva .

if u Using Qlikview 11 ,use Alternate sate  Options  in listbox.

Regards

Perumal A

siva_boggarapu
Contributor II

Help required

Hi Perumal,

Sorry I am using Qlikview 10.

Best,

Siva.

siva_boggarapu
Contributor II

Help required

Hello There,

If anyone cann't understand, I can explain very clearly. But Its very urgetnt.

Best,

Siva

MVP
MVP

Re: Help required

Siva

If the values in the three columns are associated in any way, then a selection in one list box will affect the possible values or selection in the other list boxes. This behaviour is by design and cannot be overridden.

Assuming that the columns are not associated, then I think you will need to use OnSelect triggers for Col1 and Col2. The OnSelect trigger for Col1 should fire an action to clear the selections on Col2 and Col3 (Select in Field action, Search String "=null()")  . Likewise the OnSelect trigger for Col2 should clear the selections on Col3. I expect that this approach will fail if the fields are associated.

Hope that helps

Jonathan

siva_boggarapu
Contributor II

Help required

Hello Jonathan,

My three listboxes are associated. Is there any other way can I do this?

Best,

Siva

Help required

Hi,

    Tell us what u want to achieve by doing this. There may be chances that same can be done with some other logic.

    Also tell us which values from listbox 1 should be selected when what value is selected in listbox 2 and same for listbox 3.

Regards,

Kaushik Solanki

siva_boggarapu
Contributor II

Help required

Hi Kaushik,

I send my requirement to your mail kaushik.solanki@predoole.com.

Please do the needful.

Best,

Siva

Help required

Hi,

   I am still not clear about why you want to do this.

   Are you going to compare them?

Regards,

Kaushik Solanki

siva_boggarapu
Contributor II

Help required

Hi Kaushik,

Yes, I want to compare them.

best,

Siva.