Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thomakel
Contributor III
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 

6 Replies
YoussefBelloum
Champion
Champion

Hi,

unfortunately you can't do it without extensions..

try this one: Qlik Branch

thomakel
Contributor III
Contributor III
Author

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

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

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
Contributor III
Contributor III
Author

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

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