topic Re: Activating a sheet based on list value selection. in QlikView

Activating a sheet based on list value selection.

ksasidhars — Mon, 20 Feb 2012 17:53:43 GMT

Hi,

Could anyone help me to activate sheed based on a value selection in a list box. I couldn't pass the Sheet ID properly while activating the trigger in Document properties. Thanks in advance.

- Sasi

Activating a sheet based on list value selection.

swuehl — Mon, 20 Feb 2012 18:15:47 GMT

Could you post your sample app? Or could you descibe your problem is bit closer?

Re: Activating a sheet based on list value selection.

ksasidhars — Mon, 20 Feb 2012 19:16:40 GMT

Hi Swuehl, Please find the attached application. I'm trying to activate Sheets A,B based on the corresponding selection in the list. I couldn't get this working.Please let me know if you need any details from me. Thanks

Activating a sheet based on list value selection.

Mon, 20 Feb 2012 19:25:26 GMT

In your variable vSheet use maxString(SID)

Re: Activating a sheet based on list value selection.

Larry_Aaron — Mon, 20 Feb 2012 19:26:38 GMT

Look a the Sheet Properties > General tab > Show Sheet > Conditional

Activating a sheet based on list value selection.

swuehl — Mon, 20 Feb 2012 19:26:53 GMT

Just change your sheet ID expression in your activate sheet action (document properties) to

=SID

Regards,

Stefan

Re: Activating a sheet based on list value selection.

ksasidhars — Mon, 20 Feb 2012 19:30:42 GMT

Thanks all for your help. It works now. Fed's input works for me . - Sasi

Re: Activating a sheet based on list value selection.

romtech1 — Wed, 25 Jul 2018 11:35:37 GMT

Its fine , but if I select Sheet A it is getting visible but the focus remains on list box ,what to do for the the sheet A activated and focus got to Sheet A