Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

thomakel
New Contributor III

"GetActiveSheetId()" or how to get title of sheet?

Hi,

how to get the sheet title or sheet ID of current sheet?
We want to set a variable base on opening sheet.

Sadly function "GetActiveSheetId()" does not exists in QlikSense.


Like in QlikView with "OnOpen" trigger:

Any ideas?

BR,
Thomas 

Tags (1)
6 Replies
YoussefBelloum
Esteemed Contributor

Re: "GetActiveSheetId()" or how to get title of sheet?

Hi,

unfortunately you can't do it without extensions..

try this one: Qlik Branch

thomakel
New Contributor III

Re: "GetActiveSheetId()" or how to get title of sheet?

THX  for recommendation!

Mhh somehow the "Set Variable Value" action is not working for me.

youssef.belloum:  Is "Set Variable Value" working for you in this extension?

I using version "QlikSense Server April 2018"

BR,
Thomas 

YoussefBelloum
Esteemed Contributor

Re: "GetActiveSheetId()" or how to get title of sheet?

Sorry I've never test it.. but people recommend it on the community.

Maybe omarbensalem‌ know how it works or can recommend you another one ?

passionate
Valued Contributor

Re: "GetActiveSheetId()" or how to get title of sheet?

Hi Thomas,

Sheetid can be found from url in Qliksense:

http://localhost:4848/sense/app/C%3A%5CUsers%5Cpankaj%5CDocuments%5CQlik%5CSense%5CApps%5CHackathon%...

Sheetid is f194e7ab-c48f-4c3e-ba24-08954fbd84a1


But how to dynamically assign this to variable is a Question.


Regards,

Pankaj

thomakel
New Contributor III

Re: "GetActiveSheetId()" or how to get title of sheet?

THX all for feedback.

youssefbelloum‌: With "SheetEvents" extension I can do "Select Value in Field" action but somehow
"Set Variable Value" is still not working for me.
I just checked available example "GuidedApp.qvf" app and it looks like "Set Variable Value" action

is also not working here.

Any other ideas how to trigger a variable value change base on sheetID in QlikSense?

Thx,
Thomas

YoussefBelloum
Esteemed Contributor

Re: "GetActiveSheetId()" or how to get title of sheet?

as soon as I found another solution I'll let you know

Community Browser