Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I want to include a chart's object ID in its windows title field, such as "Gasket Ordered - Chart 123". Is there a function to get the object ID automatically,so I don't have to type it all the time? (something like ='Gaskets Ordered'& getactiveobjectid()?
Thanks a lot for your help!
Steve
I don't think such a function exists, however you can write a simple VBScript macro that could scan all your objects and format their titles any way you want, including the Object IDs that can be obtained from the APIs.
Cheers,
Oleg Troyansky
Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!
Thanks Oleg!
I will see what I can do to write the macro.
Steve
Hi Oleg,
It was great to know about Masters Sunmmit for Qlik. I just gone through it, it is just wow..
I would like to know whether we can attend offshore as well?
Regards,
Mahamed.
Hi,
May be like this,
Using a macro,
sub GetObj
set vObj=ActiveDocument.Variables("vObj")
objs=ActiveDocument.ActiveSheet.GetActiveSheetObjects
for i=lbound(objs) to ubound(objs)
vObj.SetContent objs(i).GetObjectID(),true
next
end sub
3. Trigger this macro on each selection
Document properties---> Triggers--->onAnySelect--->Add Action---> Add--> External---> Run Macro---> Macro Name (GetObj) (Run_Macro)
4. By Calling this variable(voBj) into text box you can view your Object ID by selecting any field in the object .
PFA,
Hope this helps,
Hirish
Hi Mahamed,
Thank you for your interest in the Masters Summit for Qlik! At the moment, there are no plans for delivering the Masters Summit content remotely, however please stay tuned, in case we make changes in our delivery strategy.
The currently available options for the Masters Summit in 2016 are:
Milan - April 5-7
South Africa - September (tentative)
Austin, Texas - October
Maybe you can find a way to join one of these events?
cheers,
Oleg Troyansky
Cool. Thank you for an update.
Thanks Hirish!