Document Properties: Sheets

The Document Properties: Sheets tab helps to keep track of every sheet and sheet object of the QlikView-document. This dialog page consists of two lists, the Sheets list and the Sheet Objects list.

It is possible to sort either table on any column, by clicking its column header.

The Sheets list contains the following information:

# The sheet number (position), counting from 0.
SheetID The unique ID of the sheet.
Title The text currently shown in the sheet tab.
Status Indicates whether the sheet is normal, hidden or has a show condition.
# Objects The current number of sheet objects on the sheet.

After clicking a sheet in the list, use the buttons below to either Delete it or open its Properties dialog directly from this menu. It is also possible to Promote/Demote the sheet from here.

The Sheet Objects list contains the following information:

SheetID The unique ID of the sheet.
ObjectID Lists the unique Object ID of every existing sheet object. Linked objects have the same ID.
Type Clarifies the object type.
Caption The text currently shown in the caption of the sheet object.
ShowMode Indicates whether the object is normal, minimized, maximized, hidden or has a show condition.
CalcTime The time in milliseconds needed for the last recalculation of the object's contents. This information is only relevant for objects that are actually calculated (charts, Table boxes and any objects containing formulas).
Layer The layer as defined on the Layout page of a sheet object properties dialog, defined as Bottom, Normal or Top corresponding to the numbers -1, 0 or 1 in the list. (The layer of a sheet object can however be set to any number between -128 and +127 via the Automation API.)
Memory The amount of transient memory (in kBytes) needed for the last recalculation of the object's contents. This information is only relevant for objects that are actually calculated (charts, Table boxes and any objects containing formulas).
Left, Top, Right,
Bottom
The current position of the indicated edge of the sheet object relative to the edge of the document window, expressed in pixels.
Width, Height The size dimensions of the object, expressed in pixels.
Left (Min), Top (Min), Right (Min),
Bottom (Min)
The current position of the object when iconized (=minimized), expressed in pixels.
Width The current width of the sheet object's minimized icon, expressed in pixels.
Height The current height of the sheet object's minimized icon, expressed in pixels.
Export Structure By pressing this button it is possible to export the sheet and sheet object structure of the document to a set of text files. These text files, one for the sheets (filename.Sheets.tab), and one for the sheet objects (filename.Objects.tab) can easily be read back into QlikView for further analysis with the full power of the QlikView logic. A dialog will appear where the target folder for the export can be chosen. The default is to put the files in the same folder as the QlikView document.

After clicking an object in the list, use the buttons below to either Delete it or open its Properties dialog directly from this menu. Multiple objects can be selected with Ctrl-click.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?