Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Siva .
if u Using Qlikview 11 ,use Alternate sate Options in listbox.
Regards
Perumal A
Hi Perumal,
Sorry I am using Qlikview 10.
Best,
Siva.
Hello There,
If anyone cann't understand, I can explain very clearly. But Its very urgetnt.
Best,
Siva
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
Hello Jonathan,
My three listboxes are associated. Is there any other way can I do this?
Best,
Siva
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
Hi Kaushik,
I send my requirement to your mail kaushik.solanki@predoole.com.
Please do the needful.
Best,
Siva
Hi,
I am still not clear about why you want to do this.
Are you going to compare them?
Regards,
Kaushik Solanki
Hi Kaushik,
Yes, I want to compare them.
best,
Siva.