topic Re: Field Event Trigger in Sheet Properties in QlikView

Field Event Trigger in Sheet Properties

UzunovM93 — Fri, 15 Nov 2024 23:22:54 GMT

Hi all,

I am trying to create a link (drill down) between 2 sheets and currently am doing it through Field Event Triggers in Document Properties with actions Set Variable (To show/hide the inactive sheet) & Active Sheet (to move between sheets) for 2 sheets.

However, I am having to use additional similar sheets and would rather limit the settings to each sheet separately and their respective drill down.

Is there any way to achieve this as I couldn't do it through sheet properties?

Thanks!

Re: Field Event Trigger in Sheet Properties

Marcos_Ferreira_dos_Santos — Tue, 05 Jan 2021 15:20:44 GMT

Hi UzunovM93,

Have you solved this issue by yourself ?

If you don't, please try to bring a sample of your document in order to get help from people here in Community.

Good luck,

Marcos

Re: Field Event Trigger in Sheet Properties

UzunovM93 — Tue, 05 Jan 2021 15:24:38 GMT

Thanks Marcos,

I've found a solution using the following script in the ActivateSheet document trigger:

=IF(RIGHT(GetActiveSheetId(),4) = 'SH14','SH15',
IF(RIGHT(GetActiveSheetId(),4) = 'SH16','SH17',
IF(RIGHT(GetActiveSheetId(),4) = 'SH18','SH19',
IF(RIGHT(GetActiveSheetId(),4) = 'SH20','SH21',
IF(RIGHT(GetActiveSheetId(),4) = 'SH22','SH23',
IF(RIGHT(GetActiveSheetId(),4) = 'SH24','SH25','SH13'))))))