topic Help required in QlikView

Help required

siva_boggarapu — Tue, 05 Jun 2012 08:44:11 GMT

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

Help required

perumal_41 — Tue, 05 Jun 2012 08:58:02 GMT

Hi Siva .

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

Regards

Perumal A

Help required

siva_boggarapu — Tue, 05 Jun 2012 09:12:15 GMT

Hi Perumal,

Sorry I am using Qlikview 10.

Best,

Siva.

Help required

siva_boggarapu — Tue, 05 Jun 2012 11:41:18 GMT

Hello There,

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

Best,

Siva

Re: Help required

jonathandienst — Tue, 05 Jun 2012 12:19:35 GMT

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

Help required

siva_boggarapu — Wed, 06 Jun 2012 05:24:26 GMT

Hello Jonathan,

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

Best,

Siva

Help required

kaushiknsolanki — Wed, 06 Jun 2012 06:20:35 GMT

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

Help required

siva_boggarapu — Wed, 06 Jun 2012 06:51:37 GMT

Hi Kaushik,

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

Please do the needful.

Best,

Siva

Help required

kaushiknsolanki — Wed, 06 Jun 2012 07:20:41 GMT

Hi,

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

Are you going to compare them?

Regards,

Kaushik Solanki

Help required

siva_boggarapu — Wed, 06 Jun 2012 11:32:58 GMT

Hi Kaushik,

Yes, I want to compare them.

best,

Siva.