Suggest an Idea

[AndrewMcIlwrick]

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

[Patric_Nordstrom]

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

[JonasValleskog]

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

[Meghann_MacDonald]

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

Meghann

[PabloLabbeImaps]

Great !

[Ian_Crosland]

Hi

Please find link below to the new function:

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

thanks

Ian

[PabloLabbeImaps]

Awesome!

[Patric_Nordstrom]

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')

[Kdober]

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

[Kdober]

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?)