topic How to get object ID? in QlikView

How to get object ID?

Thu, 21 Jan 2016 15:59:52 GMT

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

Re: How to get object ID?

Oleg_Troyansky — Thu, 21 Jan 2016 18:39:44 GMT

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!

Re: How to get object ID?

Thu, 21 Jan 2016 18:58:27 GMT

Thanks Oleg!

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

Steve

Re: How to get object ID?

Mahamed_Qlik — Fri, 22 Jan 2016 07:19:33 GMT

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.

Re: How to get object ID?

HirisH_V7 — Fri, 22 Jan 2016 08:21:05 GMT

Hi,

May be like this,

Using a macro,

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

Re: How to get object ID?

Oleg_Troyansky — Fri, 22 Jan 2016 13:23:44 GMT

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

Re: How to get object ID?

Mahamed_Qlik — Fri, 22 Jan 2016 13:37:06 GMT

Cool. Thank you for an update.

Re: How to get object ID?

Fri, 22 Jan 2016 14:43:15 GMT

Thanks Hirish!