Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siva_boggarapu
Creator II
Creator 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
Partner - Specialist II
Partner - Specialist II

Hi Siva .

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

Regards

Perumal A

siva_boggarapu
Creator II
Creator II
Author

Hi Perumal,

Sorry I am using Qlikview 10.

Best,

Siva.

siva_boggarapu
Creator II
Creator II
Author

Hello There,

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

Best,

Siva

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
siva_boggarapu
Creator II
Creator II
Author

Hello Jonathan,

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

Best,

Siva

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
siva_boggarapu
Creator II
Creator II
Author

Hi Kaushik,

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

Please do the needful.

Best,

Siva

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

   Are you going to compare them?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
siva_boggarapu
Creator II
Creator II
Author

Hi Kaushik,

Yes, I want to compare them.

best,

Siva.