I am fairly new to qilkview and I am trying to create a variable that uses a chart object ID so that I can use the variable later. Is there a qlikview function I can use to get the object ID for my variable without having to create a macro ?
Thanks for any help you can give
rem ** get unique object ID for first object on sheet Main **
set s = ActiveDocument.Sheets("Main")
set so = s.SheetObjects(0)
id = so.GetObjectId
msgbox("ID = " & id)
As per my knowledge we don't have any Qlikview function to get the object ID ...you need use the Macro
See this as well?
Function to get Object ID?
Read and Write QlikView ObjectIDs by Macro – BEEYE
GetActiveObjectId() | Qlik Community
There is no direct function in Qlikview, I am not sure why you can't directly assign ID to a variable, since IDs won't change.
The only other way is Macro, but macro has lot of disadvantages it won't work in Ajax mode.
What do you want to do with these variable?
Thanks for your input guys. @ Marcus Sommer, I wanted to use the variable in a show condition for a report in report designer.
I think you could achieve this with variables and/or selections without including the object-id in anyway.
Thanks Marcus, I found a work around without using the variable and qlikview does not seem have a function that can use an object ID YET
Retrieving data ...