Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
NZFei
Partner - Specialist
Partner - Specialist

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

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

 

clipboard_image_0.png

Labels (1)
2 Solutions

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Should be coming from the hidden sheets.

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

View solution in original post

NZFei
Partner - Specialist
Partner - Specialist
Author

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

View solution in original post

8 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Should be coming from the hidden sheets.

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

NZFei
Partner - Specialist
Partner - Specialist
Author

I have tried that. No change.

SergeyMak
Partner Ambassador
Partner Ambassador

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)

clipboard_image_1.png

Regards,
Sergey
NZFei
Partner - Specialist
Partner - Specialist
Author

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):

 

clipboard_image_0.png

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Tried that.

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

NZFei
Partner - Specialist
Partner - Specialist
Author

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:

 

clipboard_image_1.png

 

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

 

SergeyMak
Partner Ambassador
Partner Ambassador

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?

Regards,
Sergey
NZFei
Partner - Specialist
Partner - Specialist
Author

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