topic Re: Is there a system variable for Sheet? in QlikView

Is there a system variable for Sheet?

Wed, 22 May 2013 20:56:48 GMT

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....

Re: Is there a system variable for Sheet?

Joaquin_Lazaro — Wed, 22 May 2013 21:02:40 GMT

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.

Re: Is there a system variable for Sheet?

calvindk — Wed, 22 May 2013 21:27:58 GMT

use =GetActiveSheetId()

Re: Is there a system variable for Sheet?

Thu, 23 May 2013 15:53:46 GMT

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!