Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
alexantone
Creator
Creator

Trigger and GetActiveSheetId()

Hello

Can i use this script in a trigger (active sheet)?

My script :

=if(GetPossibleCount(MYField)=1,GetActiveSheetId()='SH06')

Tank you

1 Reply
maxgro
MVP
MVP

it depends on what you want to do

GetActiveSheetId returns the ID of the active sheet, something like

1.png

and I think

GetActiveSheetId()='SH06'

is always false

if you want to chech SH06

=subfield(GetActiveSheetId(), '\',2)='SH06'