Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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'