Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
alexbjorlig
Contributor

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

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?

1 Solution

Accepted Solutions
stigchel
Honored Contributor

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

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.

XmlReadQvw.png

11 Replies
arulsettu
Honored Contributor III

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

sheet name available

Untitled.png

tracysmart1969
Contributor

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

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?

alexbjorlig
Contributor

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

Hi Arul - thanks for looking at my quesiton.

Please see attached:

Udklip.PNG

alexbjorlig
Contributor

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

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

arulsettu
Honored Contributor III

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

you didnt give the name for sheet?

trdandamudi
Honored Contributor

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

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

stigchel
Honored Contributor

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

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.

XmlReadQvw.png

squeakie_pig
Contributor

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

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.

alexbjorlig
Contributor

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

Hi CJ - actually very helpful!

Community Browser