Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

I have tried that. No change.

Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

Tried that.

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

Highlighted
Partner
Partner

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.

 

Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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