topic Re: How can an expression have no Sheet Name in Expression Overview? in QlikView

How can an expression have no Sheet Name in Expression Overview?

alexbjorlig — Wed, 31 Aug 2016 13:06:32 GMT

When inspecting all expressions in Qlikview (using Settings --> Expression Overview),

I often see expressions with an objectID but without a Sheet Name?

What does this mean and how are you supposed to find this Object?

Re: How can an expression have no Sheet Name in Expression Overview?

arulsettu — Wed, 31 Aug 2016 13:14:30 GMT

sheet name available

Re: How can an expression have no Sheet Name in Expression Overview?

tracysmart — Wed, 31 Aug 2016 13:22:46 GMT

you could cross reference the ObjectID in Document properties - Sheets.

It could be that they are linked objects and on multiple sheets or maybe hidden objects?

Re: How can an expression have no Sheet Name in Expression Overview?

alexbjorlig — Wed, 31 Aug 2016 13:24:22 GMT

Hi Arul - thanks for looking at my quesiton.

Please see attached:

Re: How can an expression have no Sheet Name in Expression Overview?

alexbjorlig — Wed, 31 Aug 2016 13:28:42 GMT

Could be --> but how do I find out? It is a big document so manually investigation is not an option

Re: How can an expression have no Sheet Name in Expression Overview?

arulsettu — Wed, 31 Aug 2016 13:44:10 GMT

you didnt give the name for sheet?

Re: How can an expression have no Sheet Name in Expression Overview?

trdandamudi — Wed, 31 Aug 2016 13:52:49 GMT

Based on your screen shot, it looks like that you never gave a sheet name.

Re: How can an expression have no Sheet Name in Expression Overview?

stigchel — Wed, 31 Aug 2016 14:02:51 GMT

It does seem to be the case for linked charts, I've made a test document with two sheets with the two linked charts on them and in the expression overview there is now no longer a sheet name. (Attached DateTest.qvw)

As to your problem of finding objects and or expressions, you could xml read your qvw file. In the load script editor use the table files wizard, point to your qvw document and open and in the next step set the file type to xml.

I made an example loading the first example with a table showing the SheetID, OBjectID and definition (with expression).

Now both are shown.

Re: How can an expression have no Sheet Name in Expression Overview?

squeakie_pig — Wed, 31 Aug 2016 14:19:17 GMT

Are there any hidden sheets? You could try running it through the document analyzer to see where object CH488.

I know it is not the most efficient method, but it would probably provide a definite answer.

Re: How can an expression have no Sheet Name in Expression Overview?

alexbjorlig — Thu, 01 Sep 2016 08:55:11 GMT

Hi CJ - actually very helpful!

Re: How can an expression have no Sheet Name in Expression Overview?

Anonymous — Thu, 12 Oct 2017 13:10:44 GMT

Hi! I actually found same issue today, then after looking at document propertied, sheets, there were hidden sheets. I changed the display to be always, and then in the expression overview the real name of the sheet was revealed.

Re: How can an expression have no Sheet Name in Expression Overview?

Anonymous — Wed, 01 Nov 2017 14:08:54 GMT

I found this post myself and found there were hidden sheets. When I changed the hidden sheets to be shown then there was a sheet name for them.