topic Re: Sheet Triggers?? in QlikView

Sheet Triggers??

Tue, 04 Aug 2015 14:06:08 GMT

Hi ,

I have a requirement.

PFA attached QVW which explains the requirement.

Thanks

Re: Sheet Triggers??

sorrakis01 — Tue, 04 Aug 2015 14:10:44 GMT

HI,

Check please,

Regards

Re: Sheet Triggers??

Tue, 04 Aug 2015 14:19:35 GMT

Thanks for reply.

Is it possible to activate sheets and redirecting to respective Sheet by selecting the ID, as we dont provide users to select Party. Also we have many ID. Attached QVW was just a mock up.

Re: Sheet Triggers??

Kushal_Chawda — Tue, 04 Aug 2015 14:21:13 GMT

You can use the field event trigger (Activate Sheet) on field Party

See the atached

Re: Sheet Triggers??

sorrakis01 — Tue, 04 Aug 2015 14:23:50 GMT

Yes,

You can create triggers of all List Tables.

Regards

Re: Sheet Triggers??

Tue, 04 Aug 2015 14:48:48 GMT

Hi,

Suppose on Sheet1 , if user select ID 5 is it possible to redirect user to Sheet2?

Likewise on Sheet2 , if user select ID 1 is it possible to redirect user to Sheet21?

Re: Sheet Triggers??

sorrakis01 — Wed, 05 Aug 2015 06:34:30 GMT

Hi,

You need to do the same that party but on ID, but you need to get the name of the activated sheet (you can use:

SubField(GetActiveSheetId(),'\',2) to get it).

Check on the example.

Regards,

Re: Sheet Triggers??

sorrakis01 — Fri, 07 Aug 2015 07:48:59 GMT

Hi Robert,

You could resolve the problem?

Regards