topic Re: Locating chart objects in QlikView

Locating chart objects

Anonymous — Mon, 21 Dec 2015 14:15:55 GMT

Hi,

I have a QVW file which contains about 70+ objects. Is there an easy to find the object and be able to locate

it directly? For example, say I have an object ID and it's CH50. I want to go this object directly but don't know which sheet

contains it. I could go through one by one and eventually I'll find it. Just looking for an efficient way.

Thanks

Re: Locating chart objects

jyothish8807 — Mon, 21 Dec 2015 14:20:56 GMT

Hi sidneylu,

I don't think so there is any short cut to identify the chart.

May be using macros you can create some logic to activate the chart.

Regards

Re: Locating chart objects

Mon, 21 Dec 2015 14:21:27 GMT

Hi sidneylu,

Settings-->sheet properties-->Objects

Re: Locating chart objects

settu_periasamy — Mon, 21 Dec 2015 14:25:42 GMT

May be,

Document Properties -> Sheets Tab

It will list All the Sheets and Objects..

Re: Locating chart objects

Anonymous — Mon, 21 Dec 2015 14:28:04 GMT

Ramanjan

This will show me all the objects for the sheet I'm on. This isn't exactly what I'm looking for. I need to go to the object

directly given the object id.

Re: Locating chart objects

Anonymous — Mon, 21 Dec 2015 14:43:02 GMT

Yes, I did look into Document Properties -> Sheets. But there is no "go to" button for the object I'm interested in.

Re: Locating chart objects

Mon, 21 Dec 2015 14:44:43 GMT

if you go to settings/document properpies sheet tab, by default, the bottom pane will list all objects for all sheets

you can click on the object ID column to sort the object, which will make it easier to find - once you find the object, you can then see the sheet it is on, as well as other object characteristics

Re: Locating chart objects

roger_stone — Mon, 21 Dec 2015 14:45:39 GMT

You can double-click the ObjectID heading to sort them, then scroll to the object you're looking for.

Re: Locating chart objects

Peter_Cammaert — Mon, 21 Dec 2015 14:46:01 GMT

No there is not, sorry.

Objects can be invisible, or hidden below another object, or hidden in a container object. These are only a few examples of objects where your Goto-button wouldn't work anyway.

Re: Locating chart objects

Peter_Cammaert — Mon, 21 Dec 2015 14:49:19 GMT

BTW the Sheet Properties->Objects tab has a visibility flag, object position information and a layer index as well. Should be helpful when locating hidden objects. Don't forget that entire sheets may be hidden as well. Fortunately sheet visibility doesn't affect the availability of properties access in Settings->Document Properties->Sheets.

Re: Locating chart objects

Anonymous — Mon, 21 Dec 2015 14:55:10 GMT

Adam,

Yes, it looks like that's what I have to do. I wish there was a feature in the tool to do a "Find" and "Activate"

the object. Thanks for everyone's help.

Re: Locating chart objects

Anonymous — Mon, 21 Dec 2015 15:02:10 GMT

If you go to :

Settings
Document Properties
Sheets

You see a list of all the Objects.

Find your Object and then you can the Sheet ID and Caption.

Still not perfect. but better than just looking blind.

Re: Locating chart objects

vcanale — Tue, 22 Dec 2015 11:55:06 GMT

Re: Locating chart objects

jyothish8807 — Tue, 22 Dec 2015 12:57:45 GMT

Hi sidneylu,

As i mentioned above, it can only be achieved by creating some logic using macros.

Regards

Re: Locating chart objects

Anonymous — Tue, 22 Dec 2015 13:13:13 GMT

Would you know how to write this macro? I'm interested to see what the code looks like but I don't know how

to write it as I'm new to QV development. Thanks