Is there a system variable for Sheet?

[#1]

Is there a system variable for Sheet?  If so, I can't find it.

I want to write an expression like =If(SheetSystemVariable='SH02',Sales+1)

So it only happens when the person is on the sheet SH02 and NOT on any other sheet.

(I acutally want to use this on a document trigger so the event only occurs on 1 sheet and not on any others)

If there is no system variable I guess the workaround will be to create my own and set a trigger on the sheet to set my defined variable to SH02 when they hit this sheet.  Which would work, but seems like there should already be a QlikView default variable of SheetID or something.   SO I thought I would ask here....

[Joaquin_Lazaro]

Hello rlowe123

If you need a trigger in only one sheet, you could with Ctrl+Alt+S or Settings/Sheet Properties and select the Trigger tab.

Hope it help you.

[calvindk · Accepted solution]

use =GetActiveSheetId()

[#4]

Thanks, GetActiveSheet was what I was looking for.   I see it returns 'document\SH01' versus just 'SH01'.  I wonder why.  But that's easy enough to work around, I just would have thought it would only return the sheet value.  THANKS VERY MUCH!