How to get object ID?

[#1]

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

[Oleg_Troyansky]

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!

[#3 · Accepted solution]

Thanks Oleg!

I will see what I can do to write the macro.

Steve

[Mahamed_Qlik]

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.

[HirisH_V7]

Hi,

May be like this,

Using a macro,

1. Create a  variable vObj
2. Create 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

[Oleg_Troyansky]

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

[Mahamed_Qlik]

Cool. Thank you for an update.

[#8]

Thanks Hirish!