topic Re: Why are there some objects in no-name sheets in QV? in QlikView

Why are there some objects in no-name sheets in QV?

NZFei — Sat, 16 Nov 2024 02:27:41 GMT

Where can I find these no-name sheets? Can I delete the objects or related fields under these sheets?

Re: Why are there some objects in no-name sheets in QV?

Arthur_Fong — Wed, 18 Sep 2019 02:54:21 GMT

Should be coming from the hidden sheets.

Try unhide all sheets and see if the no-name sheets still appear.

Re: Why are there some objects in no-name sheets in QV?

NZFei — Wed, 18 Sep 2019 02:57:21 GMT

I have tried that. No change.

Re: Why are there some objects in no-name sheets in QV?

SergeyMak — Wed, 18 Sep 2019 03:25:38 GMT

You can find those in Settings\Document Properties on Sheets tab.

As you already have Object IDs you can find them in the list and click properties to see what it all about or delete them (just click Delete)

Re: Why are there some objects in no-name sheets in QV?

NZFei — Wed, 18 Sep 2019 03:32:16 GMT

No, it is not there.

See the object CH372 in a no-name sheet in my original post. It is not in the object list (I have sorted the ObjectID):

Re: Why are there some objects in no-name sheets in QV?

Arthur_Fong — Wed, 18 Sep 2019 03:32:20 GMT

Tried that.

You cant find those expressions without sheetID at Document Properties > Sheet.

Re: Why are there some objects in no-name sheets in QV?

NZFei — Wed, 18 Sep 2019 03:58:55 GMT

Yes, you are right.

We can only see sheet first before we can see the objects at Document Properties > Sheet. That is not my question.

My question is that why there are objects under no-name sheet under expression overview:

I have gone to each sheet and make sure they are all shown so no any hidden sheet at all.

Re: Why are there some objects in no-name sheets in QV?

SergeyMak — Wed, 18 Sep 2019 04:14:29 GMT

That sounds really odd.

In document properties I can see all objects from all sheets without selecting any sheet.

Even if there is no name for the sheet it still has ID like SH01 etc.

Can you share the app? Remove data from it and upload if security is a concern?

Re: Why are there some objects in no-name sheets in QV?

NZFei — Wed, 18 Sep 2019 05:00:28 GMT

Thank you guys to spend time trying to help me.

My client is using an old version QV 11.20. I replicated the issue in my new version QV 12.20.

The issue is solved by unhiding the sheets but it only works in the new version. For the old version even I have done the same, those sheets still show no name.

Cheers

Fei