topic Text object ID in expression in QlikView

Text object ID in expression

alerse — Fri, 03 Jul 2009 14:49:55 GMT

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

Text object ID in expression

blaise — Fri, 03 Jul 2009 15:00:57 GMT

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

Text object ID in expression

alerse — Fri, 03 Jul 2009 15:19:12 GMT

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!