Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
UzunovM93
Contributor II
Contributor II

Field Event Trigger in Sheet Properties

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! 

 

Labels (3)
2 Solutions

Accepted Solutions
Marcos_Ferreira_dos_Santos

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

View solution in original post

UzunovM93
Contributor II
Contributor II
Author

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'))))))


 

 

View solution in original post

2 Replies
Marcos_Ferreira_dos_Santos

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

UzunovM93
Contributor II
Contributor II
Author

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'))))))