Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
alerse
Contributor III
Contributor III

Text object ID in expression

Hi

How Can I get the Object ID to use in an expression? E.g. I want to display the Object ID as hover text (help text).

Thanks!

Eon

2 Replies
blaise
Partner - Specialist
Partner - Specialist

I dont know if you can fetch the Object ID with an expression, pretty sure you cant.

I declare all my help texts as variables (inside a qvs file), and then assign them to the appropriate objects. This way its a lot easier to replace strings that are present in more then one object help text, aswell as doing other changes (like spelling corrections).

alerse
Contributor III
Contributor III
Author

Hi Blaise

Thanks for the reply. The real reason I want to use the ID is a bit more complex than just for a standard help text. Basically I need any unique field in the text object.

Currently I use variables at a few places (e.g. my code for the help text:



=Maxstring(If([L1] = VarL1Out and Isnull([L2]),[HoverText])) & '. Actual: '


&Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Actual])) & '. Target: '


&Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Target]))







and for my calculated colour:



=if(Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Actual]))>Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Target])),Green(),if(Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Actual]))<Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Target])),Red(),Yellow()))


I thought that if I can change my Object ID to VarL1Out and use $(=objectID) as the variable (in this case VarL1Out) it will save me a lot of time if I want to duplicate this solution. THen I dont have to change the variables in all the places butonly in the object ID!

Hope this makes sense!