topic Disable a listbox when ... in QlikView

Disable a listbox when ...

Wed, 21 Mar 2012 10:50:41 GMT

Hi guys,

I'm in trouble with a listbox.

I'd like to enable or disable a listbox when I select a field of another listbox.

For instance. I have two list box A & B.

If I select a field in listbox A, I don't want that the customer can select a field in listbox B.

Is it possible?

Thank you so much in advance.

Re: Disable a listbox when ...

sivarajs — Wed, 21 Mar 2012 10:58:31 GMT

Hi,

u meant to say if A is selected there should not be anything selected in B(disable)

Can u clear that..

Disable a listbox when ...

CELAMBARASAN — Wed, 21 Mar 2012 10:59:35 GMT

Hi,

Use macro to do this.

To disable the LB01 list box this should call on on select trigger

Document properties-->Triggers-->Fields

Sub LB01

set LB = ActiveDocument.GetSheetObject("LB01")

set box=LB.GetProperties

box.Layout.ReadOnly = true

LB.SetProperties box

End Sub

Re: Disable a listbox when ...

jvitantonio — Wed, 21 Mar 2012 11:00:56 GMT

Hi, is this what you need?

Disable a listbox when ...

Wed, 21 Mar 2012 11:03:21 GMT

Hi Sivaraj,

thank you.

Yes, if I select a field in A I don't have to select a field in B.

Hope it helps.

Disable a listbox when ...

jvitantonio — Wed, 21 Mar 2012 11:06:02 GMT

Giampiero, have you seen my solution? It does what you need. Please confirm

Re: Disable a listbox when ...

sivarajs — Wed, 21 Mar 2012 11:09:38 GMT

use

if(getselectedcount(A)=0,B) in list box

if u select anything in A it dont any show option in B

Disable a listbox when ...

Wed, 21 Mar 2012 11:19:26 GMT

Hi Celambarasan,

I'm not sure to understand how it works.

I create a macro LB01 then Triggers->Fields i used the macro but it doesn't work.

I'm sure I did something wrong.

I try again

THANK YOU SO MUCH

Disable a listbox when ...

Wed, 21 Mar 2012 11:21:23 GMT

Hi,

Thank you so much.

It works. It helps me.

May you explain me how it works? i mean, what have you done?

i don't understand. No expression. no actions. no Macro.

Thanks a lot

Disable a listbox when ...

Wed, 21 Mar 2012 11:22:57 GMT

Hi Sivarj,

thank you so much.

It's a good idea, but it's not exactly what I need to.

I'll try to follow this way to find a new solution.

Thanks a lot

Disable a listbox when ...

jvitantonio — Wed, 21 Mar 2012 11:51:16 GMT

That's the nice thing about it

In your second listbox, you put an expression that is says

"if yhere are not elements sected in the first list box, then show the field, otherwise do nothing"

Go to the second list box properties, and check the expression. It's really simple.

Disable a listbox when ...

Wed, 21 Mar 2012 16:16:42 GMT

I wrote this expression on my ListBox:

if ((isnull(getfieldselections(LB1, ',', 10))='-1'),LB2)

but it doesn't work like your example.

What's wrong in my expression?

Thanks a lot

Disable a listbox when ...

Wed, 21 Mar 2012 16:29:20 GMT

OK, Understood.

You have to insert the expression where you choice the fields of the ListBox. In the list of the Fields there is <expression>.

Thanks a lot.