Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
NEW Customer Portal: Initial launch will improve how you submit Support Cases. FIND OUT MORE

ActiveSheetId

AndrewMcIlwrick
Luminary Alumni
Luminary Alumni

ActiveSheetId

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

15 Comments
Patric_Nordstrom
Employee
Employee

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

Status changed to: Open - Collecting Feedback
JonasValleskog
Partner - Creator
Partner - Creator

+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
Ian_Crosland
Employee
Employee
 
Status changed to: Open - In Development
PabloLabbeImaps
Partner Ambassador
Partner Ambassador

Great !

Ian_Crosland
Employee
Employee
Status changed to: Delivered
PabloLabbeImaps
Partner Ambassador
Partner Ambassador

Awesome!

Patric_Nordstrom
Employee
Employee

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

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

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