topic Re: Find Object in QlikView

Find Object

cbaqir — Wed, 27 Jan 2016 16:57:12 GMT

What's the easiest way to find an object if you know the Object ID? Also, isn't there a keyboard shortcut to restore hidden or minimized objects?

Re: Find Object

sunny_talwar — Wed, 27 Jan 2016 17:01:48 GMT

May be go to Sheets tab on document properties;

Re: Find Object

sunny_talwar — Wed, 27 Jan 2016 17:03:01 GMT

For unhidding hidden object you can try: Ctrl + Shift + S

Re: Find Object

cbaqir — Wed, 27 Jan 2016 17:03:46 GMT

I tried that but don't see the object referenced in the Governance Dashboard. I noticed containers show up but the charts within them don't.

Re: Find Object

Gysbert_Wassenaar — Wed, 27 Jan 2016 17:03:46 GMT

I find it easiest to use the Document Analyzer to find objects in document with lots of objects. You could also export the layout and find it in the exported text files.

Re: Find Object

Frank_Hartmann — Wed, 27 Jan 2016 17:05:20 GMT

You can use a macro

''****************************************************************************************

''*********************** SearchObjectID ***************************

''****************************************************************************************

Sub SearchObjectID

'Call setVariable

iObject=inputbox("Tragen Sie bitte die gewünschten Objekt-ID ein!")

for i = 0 to ActiveDocument.NoOfSheets - 1

set ss= ActiveDocument.GetSheet(i)

shNa = ss.GetProperties.Name

ActiveDocument.ActivateSheet(shNa)

ActiveDocument.GetApplication.WaitForIdle()

Objecte = ActiveDocument.ActiveSheet.GetSheetObjects

For j = lBound(Objecte) to ubound(Objecte)

if Objecte(j).GetObjectType = 12 or Objecte(j).GetObjectType = 15 or Objecte(j).GetObjectType = 16 or Objecte(j).GetObjectType = 11 or Objecte(j).GetObjectType = 6 or Objecte(j).GetObjectType = 22 then

NameObject = Objecte(j).GetObjectID

if instr(NameObject,iObject)=0 Then

z=z+1

else

if instr(NameObject,iObject)>0 Then

set s=ActiveDocument.Sheets(i)

s.SheetObjects(iObject).Activate

msgbox("Die Objekt-ID"&" "&iObject&" "&"wurde gefunden. Falls sie das markierte Objekt nicht sehen können, wechseln sie bitte in den Entwufsmodus und starten sie das Makro erneut!")

Exit sub

else

end if

msgbox("Die Objekt-ID"&" "&"<"&iObject&"> "&"wurde NICHT gefunden. Bitte überprüfen sie ihre Eingabe auf Rechtschreibfehler")

End sub

hope it helps!

Re: Find Object

m_woolf — Wed, 27 Jan 2016 17:05:50 GMT

Shift + Ctrl + S is the shortcut for showing hidden objects.

I don't know of a command for restoring minimized objects.

You can get to the Properties of an object when you know the ID, by going to Sheet|Properties|Objects.

I don't know of a way to figure out where the object is or activate it (without using macros).

Re: Find Object

HirisH_V7 — Wed, 27 Jan 2016 17:08:26 GMT

Hi,

Still you cant find means,

where if your document has data reduction, the option 'Document Objects' will appear only if you are a ADMIN if you are a USER at the Section Access this option won't be available for you.

-Hirish