idea ActiveSheetId in Suggest an Idea

ActiveSheetId

AndrewMcIlwrick — Wed, 25 Nov 2020 08:53:26 GMT

Please can the QV function be replicated in QS : GetActiveSheetID( )

Re: ActiveSheetId - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Tue, 10 Nov 2020 12:50:20 GMT

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Related to this idea:

https://community.qlik.com/t5/Ideas/App-Detail-Functions/idi-p/1700175

Thanks,
Patric

Re: ActiveSheetId

JonasValleskog — Thu, 03 Feb 2022 15:52:14 GMT

+1. Useful when designing front end dashboards, being able to understand the sheet context allows for tailoring colours and display text accordingly and other programmatic behaviour.

Re: ActiveSheetId

Meghann_MacDonald — Thu, 12 May 2022 14:08:00 GMT

Also submitted here: https://community.qlik.com/t5/Suggest-an-Idea/Active-Sheet-Name-as-new-functions-on-Qlik-Sense/idi-p/1834465 and merged into this idea.

Meghann

Re: ActiveSheetId - Status changed to: Open - In Development

Ian_Crosland — Wed, 21 Dec 2022 11:25:49 GMT

Re: ActiveSheetId

PabloLabbeImaps — Wed, 11 Jan 2023 17:28:35 GMT

Great !

Re: ActiveSheetId - Status changed to: Delivered

Ian_Crosland — Wed, 08 Feb 2023 09:46:14 GMT

Please find link below to the new function:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/SystemFunctions/ObjectId.htm

thanks

Ian

Re: ActiveSheetId

PabloLabbeImaps — Wed, 08 Feb 2023 15:08:20 GMT

Awesome!

Re: ActiveSheetId

Patric_Nordstrom — Mon, 20 Feb 2023 09:46:06 GMT

ObjectId(type) will return the ID of the object in which the expression is evaluated.

InObject(identifier) is true when evaluated inside an object with ID identifier.

Type: sheet, table, pivot-table, text-image, filterpane, listbox, combochart, linechart, barchart, piechart, kpi, scatterplot, map etc.

Examples: Color a button dark gray when on sheet:

=if(InObject('a54a3525-aee1-4b1b-beaa-589b22bc3242'), DarkGray(), LightGray())

Inside a Text & image object:
=if(InObject(ObjectId('text-image')), 'In Text & image', 'Not in Text & image')

Re: ActiveSheetId

Cristian_Dorbesi — Tue, 07 Mar 2023 19:31:05 GMT

Hi @Patric_Nordstrom

I'm trying this on the Feb-23 (on prem) and it is not working. It says 'InObject' is not a valid function.

I tried the examples on the help section for this version and its the same. Nothing is shown, no matter if app is on development or published.

Is this already implemented?

Cheers

Cristian

Re: ActiveSheetId

Cristian_Dorbesi — Wed, 08 Mar 2023 01:12:04 GMT

Hi again.
How will this work when moving the app to another enviroment (g. dev server to prod server) or when it is published to a stream? Far as I understand the Ids are changing in this scenario, thus, quite hard to use it in conditionals, right?

Is it possible to return the name somehow? (eg, the name of the sheet?)

Re: ActiveSheetId

PabloLabbeImaps — Wed, 08 Mar 2023 11:20:17 GMT

As I know The sheetid shouldn't change when you move the app to another server or publish to a stream or even duplicate the app. Every time you create a sheet, a new unique id is generated and cannot be changed.

Re: ActiveSheetId

Meghann_MacDonald — Wed, 29 Mar 2023 14:14:32 GMT

@Cristian_Dorbesi , @PabloLabbeImaps is correct, the sheet ID will stay the same between publishing to a stream and going from stage to prod.

Re: ActiveSheetId

Meghann_MacDonald — Mon, 24 Apr 2023 14:56:03 GMT

Hi @OlivierS , this was delivered, I don't understand your comment? Is there something you are missing with the solution?

Meghann

Re: ActiveSheetId

OlivierS — Tue, 25 Apr 2023 10:40:38 GMT

hi Meghan, to my knowledge a function returning the sheet id has not been delivered or documented on Qlik Sense Saas...

Just a practical limitation example: To ease navigation on a Saas solution and configure a "go to last visited sheet" (the client want his filter on another page),i had to set up a set variable button and store the id of each page manually.... Problem is: the app keep getting new pages and the only solution we got is not viable on the long run.

Re: ActiveSheetId

Patric_Nordstrom — Wed, 26 Apr 2023 08:56:50 GMT

@Cristian_Dorbesi it's SaaS already will be in the May 2023 cm release.

@OlivierS the call is documented: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/SystemFunctions/ObjectId.htm

See my response for an example: https://community.qlik.com/t5/Suggest-an-Idea/ActiveSheetId/idc-p/2039794/highlight/true#M11968

Thanks,

Patric