topic Re: Field Activation in QlikView

Field Activation

Anonymous — Wed, 20 Feb 2013 13:29:11 GMT

Hi All,

I have two fields one with Multi box (Flight Types) and the other with list box selection (Fligh Sub Types). When ever I select a value in Multi box the list box should get activated and should show me the corresponding values of list box (Flight sub types).

I will put it in other way,

I want to be able to do two things.

1. When selecting one value in a particular multi box, it activates another list box near by.

2. When unselecting that value the list box should disappear

Is this possible in Macros or Triggers?

I think we can use triggers for this but dont know how and where to write this trigger.

Can any one help me how can i do this?

Rgds,

Nandha

Re: Field Activation

Gysbert_Wassenaar — Wed, 20 Feb 2013 14:04:11 GMT

You don't need triggers. You can use the conditional display expressions you can enter on the Layout tab of the listbox properties windows. The expression you need is something like =if(getsubstringcount([Flight Types],'Additional'),1,0)

Re: Field Activation

Anonymous — Wed, 20 Feb 2013 15:26:13 GMT

Thanks Wassenaar. But its giving me the list box if i select the first value. If i select the 2, 3, 4, etc., values the list box is not appearing.

Can you give me some ideas?

Rgds,

Nandha

Re: Field Activation

Gysbert_Wassenaar — Wed, 20 Feb 2013 15:36:41 GMT

If you want to check if any value is selected use getselectedcount([Flight Types]).

Re: Field Activation

Anonymous — Thu, 21 Feb 2013 09:29:33 GMT

Thanks a ton Wassenaar.

I have one more query will the list values disappear when I do no selection in the multi box? I mean when ever there is no selection in multi box list box should appear (heading, scroll bars and led of the list box) but the list values (names of the company) should not appear . If i select some value value in multi box the list values (names of the company) should appear in the list box.

Rgds,

Nandha

Re: Field Activation

Gysbert_Wassenaar — Thu, 21 Feb 2013 10:14:59 GMT

Yes, the listboxes are hidden until you select values. That's what you asked for in your first post:

When unselecting that value the list box should disappear

If you want empty listboxes to be shown then the easiest way is use table boxes instead and make them look like listboxes.

Re: Field Activation

Anonymous — Thu, 21 Feb 2013 10:25:06 GMT

Thnx for your quick reply.

Do you have any example QVW fo this?

Re: Field Activation

Gysbert_Wassenaar — Thu, 21 Feb 2013 10:43:59 GMT

Hmm, listboxes can't be made empty easily so I had to use straight tables. See attached qvw.

Re: Field Activation

Anonymous — Thu, 21 Feb 2013 12:41:07 GMT

Sorry Wassenaar.

Have youcalled te same value both in Multi and list box (Straight Table)?

I have attached my scenario here pls help me

Rgds,

Nandha

Re: Field Activation

Gysbert_Wassenaar — Thu, 21 Feb 2013 12:46:20 GMT

Same principle, just replace the field name to what you want to show. See attached qvw.

Re: Field Activation

Anonymous — Thu, 21 Feb 2013 12:50:44 GMT

Awesome. I tried same logic but it was not working i don't know why. Anyay thanks a ton.