Click or drag to resize
Sheet Class
Inheritance Hierarchy

Namespace: Qlik.Sense.Client
Assembly: Qlik.Sense.Client (in Qlik.Sense.Client.dll) Version: 1.1.0.0 (1.1.0.0)
Syntax
public class Sheet : GenericObject, ISheet, 
	IEnumerable<SheetCell>, IEnumerable, IGenericObject, IQixClassBase, 
	IDisposable

The Sheet type exposes the following members.

Constructors
  NameDescription
Public methodSheet
Initializes a new instance of the Sheet class
Top
Methods
  NameDescription
Public methodAbortListObjectSearch

Aborts the results of a search in a list object.

This method applies to list objects (objects with one dimension). After an abort on a list object search, the GetLayout method does not return any more search results but it does return the values in the field.
(Inherited from GenericObject.)
Public methodAbortListObjectSearchAsync

Aborts the results of a search in a list object.

This method applies to list objects (objects with one dimension). After an abort on a list object search, the GetLayout method does not return any more search results but it does return the values in the field.
(Inherited from GenericObject.)
Public methodAcceptListObjectSearch

Accept the results of a search in a list object. The search results become selected in the field.

This method applies to list objects (objects with one dimension).The search results are displayed using the GetLayout method.
(Inherited from GenericObject.)
Public methodAcceptListObjectSearchAsync

Accept the results of a search in a list object. The search results become selected in the field.

This method applies to list objects (objects with one dimension).The search results are displayed using the GetLayout method.
(Inherited from GenericObject.)
Public methodApplyPatches

Applies a patch to the properties of an object. Allows an update to some of the properties.

It is possible to apply a patch to the properties of a generic object, that is not persistent. Such a patch is called a soft patch. In that case, the result of the operation on the properties (add, remove or delete) is not shown when doing GetProperties and only a GetLayout call shows the result of the operation. Properties that are not persistent are called soft properties. Once the session is over, soft properties are cleared.

Soft properties apply only to generic objects.Applying a patch takes less time than resetting all the properties.
(Inherited from GenericObject.)
Public methodApplyPatchesAsync

Applies a patch to the properties of an object. Allows an update to some of the properties.

It is possible to apply a patch to the properties of a generic object, that is not persistent. Such a patch is called a soft patch. In that case, the result of the operation on the properties (add, remove or delete) is not shown when doing GetProperties and only a GetLayout call shows the result of the operation. Properties that are not persistent are called soft properties. Once the session is over, soft properties are cleared.

Soft properties apply only to generic objects.Applying a patch takes less time than resetting all the properties.
(Inherited from GenericObject.)
Public methodBeginSelections

Begins the selection mode. The app enters the modal state. The specified object enters the selection mode and a modal window is opened. The selection mode can apply to only one object in an app at a time.

When a visualization is in selection mode, selections can be made in this visualization. The visualization is not sorted until the selection mode is ended. Once the selection mode is ended and if the selections are accepted, the visualization is sorted according to the sort criteria. For more information about:

* Ending the selection mode, see EndSelections method.

* The sort criteria, see ListObjectDef or HyperCubeDef.

Example:  

A sheet contains a list object and a chart. If the list object is in selection mode then the chart cannot be in selection mode. No selection on the chart can be made until the list object exits the selection mode.

(Inherited from GenericObject.)
Public methodBeginSelectionsAsync

Begins the selection mode. The app enters the modal state. The specified object enters the selection mode and a modal window is opened. The selection mode can apply to only one object in an app at a time.

When a visualization is in selection mode, selections can be made in this visualization. The visualization is not sorted until the selection mode is ended. Once the selection mode is ended and if the selections are accepted, the visualization is sorted according to the sort criteria. For more information about:

* Ending the selection mode, see EndSelections method.

* The sort criteria, see ListObjectDef or HyperCubeDef.

Example:  

A sheet contains a list object and a chart. If the list object is in selection mode then the chart cannot be in selection mode. No selection on the chart can be made until the list object exits the selection mode.

(Inherited from GenericObject.)
Public methodClearSelections

Clears the selections in a dimension of a visualization.

(Inherited from GenericObject.)
Public methodClearSelectionsAsync

Clears the selections in a dimension of a visualization.

(Inherited from GenericObject.)
Public methodClearSoftPatches

Clears the soft properties of a generic object.

For more information on how to add soft properties to a generic object, see ApplyPatches method.

(Inherited from GenericObject.)
Public methodClearSoftPatchesAsync

Clears the soft properties of a generic object.

For more information on how to add soft properties to a generic object, see ApplyPatches method.

(Inherited from GenericObject.)
Public methodCollapseLeft

Collapses the left dimensions of a pivot table. This method applies only to pivot tables that are not always fully expanded.

In the definition of the hypercube (in HyperCubeDef), the parameter qAlwaysFullyExpanded must be set to false.

(Inherited from GenericObject.)
Public methodCollapseLeftAsync

Collapses the left dimensions of a pivot table. This method applies only to pivot tables that are not always fully expanded.

In the definition of the hypercube (in HyperCubeDef), the parameter qAlwaysFullyExpanded must be set to false.

(Inherited from GenericObject.)
Public methodCollapseTop

Collapses the top dimensions of a pivot table. This method applies only to pivot tables that are not always fully expanded.

In the definition of the hypercube (in HyperCubeDef), the parameter qAlwaysFullyExpanded must be set to false.

(Inherited from GenericObject.)
Public methodCollapseTopAsync

Collapses the top dimensions of a pivot table. This method applies only to pivot tables that are not always fully expanded.

In the definition of the hypercube (in HyperCubeDef), the parameter qAlwaysFullyExpanded must be set to false.

(Inherited from GenericObject.)
Public methodCopyFrom

Copies the properties of a generic object and its children.

The source object is specified by the parameter qFromId and the destination object is referenced by its handle.

The identifier of the destination object is the same as before the copy takes place.
(Inherited from GenericObject.)
Public methodCopyFromAsync

Copies the properties of a generic object and its children.

The source object is specified by the parameter qFromId and the destination object is referenced by its handle.

The identifier of the destination object is the same as before the copy takes place.
(Inherited from GenericObject.)
Public methodCreateBarchart
Public methodCreateBarchartAsync
Public methodCreateChildT
Creation of child generic object
(Inherited from GenericObject.)
Public methodCreateChildAsyncT
Async creation of child generic object
(Inherited from GenericObject.)
Public methodCreateCombochart
Public methodCreateCombochartAsync
Public methodCreateFilterpane
Public methodCreateFilterpaneAsync
Public methodCreateGauge
Public methodCreateGaugeAsync
Public methodCreateKpi
Public methodCreateKpiAsync
Public methodCreateLinechart
Public methodCreateLinechartAsync
Public methodCreateListbox
Public methodCreateListboxAsync
Public methodCreateMap
Public methodCreateMapAsync
Public methodCreatePiechart
Public methodCreatePiechartAsync
Public methodCreatePivotTable
Public methodCreatePivotTableAsync
Public methodCreateScatterplot
Public methodCreateScatterplotAsync
Public methodCreateTable
Public methodCreateTableAsync
Public methodCreateTextImage
Public methodCreateTextImageAsync
Public methodCreateTreemap
Public methodCreateTreemapAsync
Public methodDefCount
Retrieves the total number of HyperCube/ListObject definitions contained in this generic object
(Inherited from GenericObject.)
Public methodDefCountAsync
Retrieves the total number of HyperCube/ListObject definitions contained in this generic object asyncronously
(Inherited from GenericObject.)
Public methodDefPathAtIndex(Int32)
Converts an existing index to its equivalent path value
(Inherited from GenericObject.)
Public methodDefPathAtIndex(Int32)
Converts existing index values to their equivalent path values
(Inherited from GenericObject.)
Public methodDefPathAtIndexAsync(Int32)
Converts an existing index to its equivalent path value asyncronously
(Inherited from GenericObject.)
Public methodDefPathAtIndexAsync(Int32)
Converts existing index values to their equivalent path values asyncronously
(Inherited from GenericObject.)
Public methodDestroyAllChildren

Removes all children and all children to the children on an object.

(Inherited from GenericObject.)
Public methodDestroyAllChildrenAsync

Removes all children and all children to the children on an object.

(Inherited from GenericObject.)
Public methodDestroyChild

Removes a child object.

It is possible to update the properties of the child's parent at the same time that the child is removed. Both operations are performed by the same call.Removing a linked object, invalidate the linking object.
(Inherited from GenericObject.)
Public methodDestroyChildAsync(String, GenericObjectProperties, AsyncHandle)
Async destruction of child.
(Inherited from GenericObject.)
Public methodDestroyChildAsyncT(String, GenericObjectProperties, FuncResponse, T, AsyncHandle)
Async destruction of child.
(Inherited from GenericObject.)
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
(Inherited from QixClassBase.)
Public methodDrillUp

You can use the drillUp method with any object that contains a drill-down group as a dimension.

This method allows you to move between different levels of information (from a detailed level to a less detailed level of information). You can go back to previous visualizations up to the highest level of the hierarchy.

If you try to drill up more steps than there are available levels, the first level of the hierarchy is displayed.

(Inherited from GenericObject.)
Public methodDrillUpAsync

You can use the drillUp method with any object that contains a drill-down group as a dimension.

This method allows you to move between different levels of information (from a detailed level to a less detailed level of information). You can go back to previous visualizations up to the highest level of the hierarchy.

If you try to drill up more steps than there are available levels, the first level of the hierarchy is displayed.

(Inherited from GenericObject.)
Public methodDuplicateAs
DuplicateAs
(Inherited from GenericObject.)
Public methodDuplicateAsAsync
DuplicateAs
(Inherited from GenericObject.)
Public methodEmbedSnapshotObject

Adds a snapshot to a generic object.

Only one snapshot can be embedded in a generic object.If you embed a snapshot in an object that already contains a snapshot, the new snapshot overwrites the previous one.
(Inherited from GenericObject.)
Public methodEmbedSnapshotObjectAsync

Adds a snapshot to a generic object.

Only one snapshot can be embedded in a generic object.If you embed a snapshot in an object that already contains a snapshot, the new snapshot overwrites the previous one.
(Inherited from GenericObject.)
Public methodEndSelections

Ends the selection mode on a visualization. The selections are accepted or aborted when exiting the selection mode, depending on the qAccept parameter value.

(Inherited from GenericObject.)
Public methodEndSelectionsAsync

Ends the selection mode on a visualization. The selections are accepted or aborted when exiting the selection mode, depending on the qAccept parameter value.

(Inherited from GenericObject.)
Public methodExpandLeft

Expands the left dimensions of a pivot table. This method applies only to pivot tables that are not always fully expanded.

In the definition of the hypercube (in HyperCubeDef), the parameter qAlwaysFullyExpanded must be set to false.

(Inherited from GenericObject.)
Public methodExpandLeftAsync

Expands the left dimensions of a pivot table. This method applies only to pivot tables that are not always fully expanded.

In the definition of the hypercube (in HyperCubeDef), the parameter qAlwaysFullyExpanded must be set to false.

(Inherited from GenericObject.)
Public methodExpandTop

Expands the top dimensions of a pivot table. This method applies only to pivot tables that are not always fully expanded.

In the definition of the hypercube (in HyperCubeDef), the parameter qAlwaysFullyExpanded must be set to false.

(Inherited from GenericObject.)
Public methodExpandTopAsync

Expands the top dimensions of a pivot table. This method applies only to pivot tables that are not always fully expanded.

In the definition of the hypercube (in HyperCubeDef), the parameter qAlwaysFullyExpanded must be set to false.

(Inherited from GenericObject.)
Public methodExportData

Exports the data of any generic object to an Excel file or a open XML file.

If the object contains excluded values, those excluded values are not exported.

(Inherited from GenericObject.)
Public methodExportDataAsync(NxExportFileType, String, String, NxExportState, AsyncHandle)

Exports the data of any generic object to an Excel file or a open XML file.

If the object contains excluded values, those excluded values are not exported.

(Inherited from GenericObject.)
Public methodExportDataAsyncT(NxExportFileType, String, String, NxExportState, FuncResponse, T, AsyncHandle)

Exports the data of any generic object to an Excel file or a open XML file.

If the object contains excluded values, those excluded values are not exported.

(Inherited from GenericObject.)
Public methodGetBarchart
Public methodGetBarchartAsync
Public methodGetChild

Returns the type of the object and the corresponding handle.

(Inherited from GenericObject.)
Public methodGetChildAsync(String, AsyncHandle)

Returns the type of the object and the corresponding handle.

(Inherited from GenericObject.)
Public methodGetChildAsyncT(String, FuncResponse, T, AsyncHandle)

Returns the type of the object and the corresponding handle.

(Inherited from GenericObject.)
Public methodGetChildInfos

Returns the identifier and the type for each child in an app object. If the child contains extra properties in qInfos,these properties are returned.

(Inherited from GenericObject.)
Public methodGetChildInfosAsync(AsyncHandle)

Returns the identifier and the type for each child in an app object. If the child contains extra properties in qInfos,these properties are returned.

(Inherited from GenericObject.)
Public methodGetChildInfosAsyncT(FuncResponse, T, AsyncHandle)

Returns the identifier and the type for each child in an app object. If the child contains extra properties in qInfos,these properties are returned.

(Inherited from GenericObject.)
Public methodGetCombochart
Public methodGetCombochartAsync
Public methodGetEnumerator
Returns an enumerator that iterates through the collection.
Public methodGetFilterpane
Public methodGetFilterpaneAsync
Public methodGetFullPropertyTree

Gets the properties of:

* a generic object

* the children of the generic object

* the bookmarks/embedded snapshots of the generic object

(Inherited from GenericObject.)
Public methodGetFullPropertyTreeAsync(AsyncHandle)

Gets the properties of:

* a generic object

* the children of the generic object

* the bookmarks/embedded snapshots of the generic object

(Inherited from GenericObject.)
Public methodGetFullPropertyTreeAsyncT(FuncResponse, T, AsyncHandle)

Gets the properties of:

* a generic object

* the children of the generic object

* the bookmarks/embedded snapshots of the generic object

(Inherited from GenericObject.)
Public methodGetGauge
Public methodGetGaugeAsync
Public methodGetHyperCubeData

Retrieves the values of a chart, a table, or a scatter plot. It is possible to retrieve specific pages of data.

This method does not apply to stacked tables.
(Inherited from GenericObject.)
Public methodGetHyperCubeDataAsync(String, IEnumerableNxPage, AsyncHandle)

Retrieves the values of a chart, a table, or a scatter plot. It is possible to retrieve specific pages of data.

This method does not apply to stacked tables.
(Inherited from GenericObject.)
Public methodGetHyperCubeDataAsyncT(String, IEnumerableNxPage, FuncResponse, T, AsyncHandle)

Retrieves the values of a chart, a table, or a scatter plot. It is possible to retrieve specific pages of data.

This method does not apply to stacked tables.
(Inherited from GenericObject.)
Public methodGetHyperCubePivotData

Retrieves the values of a pivot table. It is possible to retrieve specific pages of data.

(Inherited from GenericObject.)
Public methodGetHyperCubePivotDataAsync(String, IEnumerableNxPage, AsyncHandle)

Retrieves the values of a pivot table. It is possible to retrieve specific pages of data.

(Inherited from GenericObject.)
Public methodGetHyperCubePivotDataAsyncT(String, IEnumerableNxPage, FuncResponse, T, AsyncHandle)

Retrieves the values of a pivot table. It is possible to retrieve specific pages of data.

(Inherited from GenericObject.)
Public methodGetHyperCubeReducedData

Reduces the data of a bar chart, a line chart or a scatter plot chart and retrieves them.

The reduction is dependent on the zoom factor (parameter qZoomFactor) and on the reduction mode.

** Bar chart or line chart data reduction **

For the data reduction to happen, the following conditions must be fulfilled:

* The values cannot fit in the defined page (parameter qPages).

* The zoom factor is not 0 (parameter qZoomFactor).

* The reduction mode must be set to D1.

The reduction algorithm keeps the shape of the visualizations and works whatever the number of dimensions in the chart. The global profile of the chart is reduced, and not only a specific dimension. A visualization that has been reduced contains fewer values but its shape is the same. Data of all types can be reduced. Therefore it is hard to relate the values before and after a reduction especially when reducing string values.

Example:  

If you have a chart with 1 million data, and you have set the zoom factor to 5, the GetHyperCubeReducedData method reduces the chart and retrieves 200 000 data.

** Scatter plot chart data reduction **

The reduction mode must be set to C.

This reduction mechanism follows the 2D K-Means algorithm. Data are reduced into a number of clusters. Each data is assigned to a specific centroid.

The number of centroids can be defined in the parameter qZoomFactor.

** Scatter plot chart resolution reduction **

The reduction mode must be set to S.

The resolution is reduced according to the zoom factor (parameter qZoomFactor).

Example:  

If you have a scatter plot chart and the zoom factor is set to 2, the scatter plot chart resolution is reduced by 4.

(Inherited from GenericObject.)
Public methodGetHyperCubeReducedDataAsync(String, IEnumerableNxPage, Int32, NxDataReductionMode, AsyncHandle)

Reduces the data of a bar chart, a line chart or a scatter plot chart and retrieves them.

The reduction is dependent on the zoom factor (parameter qZoomFactor) and on the reduction mode.

** Bar chart or line chart data reduction **

For the data reduction to happen, the following conditions must be fulfilled:

* The values cannot fit in the defined page (parameter qPages).

* The zoom factor is not 0 (parameter qZoomFactor).

* The reduction mode must be set to D1.

The reduction algorithm keeps the shape of the visualizations and works whatever the number of dimensions in the chart. The global profile of the chart is reduced, and not only a specific dimension. A visualization that has been reduced contains fewer values but its shape is the same. Data of all types can be reduced. Therefore it is hard to relate the values before and after a reduction especially when reducing string values.

Example:  

If you have a chart with 1 million data, and you have set the zoom factor to 5, the GetHyperCubeReducedData method reduces the chart and retrieves 200 000 data.

** Scatter plot chart data reduction **

The reduction mode must be set to C.

This reduction mechanism follows the 2D K-Means algorithm. Data are reduced into a number of clusters. Each data is assigned to a specific centroid.

The number of centroids can be defined in the parameter qZoomFactor.

** Scatter plot chart resolution reduction **

The reduction mode must be set to S.

The resolution is reduced according to the zoom factor (parameter qZoomFactor).

Example:  

If you have a scatter plot chart and the zoom factor is set to 2, the scatter plot chart resolution is reduced by 4.

(Inherited from GenericObject.)
Public methodGetHyperCubeReducedDataAsyncT(String, IEnumerableNxPage, Int32, NxDataReductionMode, FuncResponse, T, AsyncHandle)

Reduces the data of a bar chart, a line chart or a scatter plot chart and retrieves them.

The reduction is dependent on the zoom factor (parameter qZoomFactor) and on the reduction mode.

** Bar chart or line chart data reduction **

For the data reduction to happen, the following conditions must be fulfilled:

* The values cannot fit in the defined page (parameter qPages).

* The zoom factor is not 0 (parameter qZoomFactor).

* The reduction mode must be set to D1.

The reduction algorithm keeps the shape of the visualizations and works whatever the number of dimensions in the chart. The global profile of the chart is reduced, and not only a specific dimension. A visualization that has been reduced contains fewer values but its shape is the same. Data of all types can be reduced. Therefore it is hard to relate the values before and after a reduction especially when reducing string values.

Example:  

If you have a chart with 1 million data, and you have set the zoom factor to 5, the GetHyperCubeReducedData method reduces the chart and retrieves 200 000 data.

** Scatter plot chart data reduction **

The reduction mode must be set to C.

This reduction mechanism follows the 2D K-Means algorithm. Data are reduced into a number of clusters. Each data is assigned to a specific centroid.

The number of centroids can be defined in the parameter qZoomFactor.

** Scatter plot chart resolution reduction **

The reduction mode must be set to S.

The resolution is reduced according to the zoom factor (parameter qZoomFactor).

Example:  

If you have a scatter plot chart and the zoom factor is set to 2, the scatter plot chart resolution is reduced by 4.

(Inherited from GenericObject.)
Public methodGetHyperCubeStackData

Retrieves the values of a stacked pivot table. It is possible to retrieve specific pages of data.

(Inherited from GenericObject.)
Public methodGetHyperCubeStackDataAsync(String, IEnumerableNxPage, Int32, AsyncHandle)

Retrieves the values of a stacked pivot table. It is possible to retrieve specific pages of data.

(Inherited from GenericObject.)
Public methodGetHyperCubeStackDataAsyncT(String, IEnumerableNxPage, Int32, FuncResponse, T, AsyncHandle)

Retrieves the values of a stacked pivot table. It is possible to retrieve specific pages of data.

(Inherited from GenericObject.)
Public methodGetInfo

Returns the type and identifier of the object.

(Inherited from GenericObject.)
Public methodGetInfoAsync(AsyncHandle)

Returns the type and identifier of the object.

(Inherited from GenericObject.)
Public methodGetInfoAsyncT(FuncResponse, T, AsyncHandle)

Returns the type and identifier of the object.

(Inherited from GenericObject.)
Public methodGetKpi
Public methodGetKpiAsync
Public methodGetLayout

Evaluates an object and displays its properties including the dynamic properties. If the member delta is set to true in the request object, only the delta is evaluated. A GetLayout call on a generic object, returns up to one level down in the hierarchy.

(Inherited from GenericObject.)
Public methodGetLayoutAsync(AsyncHandle)

Evaluates an object and displays its properties including the dynamic properties. If the member delta is set to true in the request object, only the delta is evaluated. A GetLayout call on a generic object, returns up to one level down in the hierarchy.

(Inherited from GenericObject.)
Public methodGetLayoutAsyncT(FuncResponse, T, AsyncHandle) (Inherited from GenericObject.)
Public methodGetLinechart
Public methodGetLinechartAsync
Public methodGetLinkedObjects

Lists the linked objects to a generic object, a dimension or a measure.

(Inherited from GenericObject.)
Public methodGetLinkedObjectsAsync(AsyncHandle)

Lists the linked objects to a generic object, a dimension or a measure.

(Inherited from GenericObject.)
Public methodGetLinkedObjectsAsyncT(FuncResponse, T, AsyncHandle)

Lists the linked objects to a generic object, a dimension or a measure.

(Inherited from GenericObject.)
Public methodGetListbox
Public methodGetListboxAsync
Public methodGetListObjectData

Retrieves the values of a list object.

(Inherited from GenericObject.)
Public methodGetListObjectDataAsync(String, IEnumerableNxPage, AsyncHandle)

Retrieves the values of a list object.

(Inherited from GenericObject.)
Public methodGetListObjectDataAsyncT(String, IEnumerableNxPage, FuncResponse, T, AsyncHandle)

Retrieves the values of a list object.

(Inherited from GenericObject.)
Public methodGetMap
Public methodGetMapAsync
Public methodGetPiechart
Public methodGetPiechartAsync
Public methodGetPivotTable
Public methodGetPivotTableAsync
Public methodGetProperties

Returns the identifier and the type of the object.

Because it is not mandatory to set all properties when you define an object, the method GetProperties may show properties that were not set. In that case, default values are given.

If the member delta is set to true in the request object, only the delta is retrieved.
(Inherited from GenericObject.)
Public methodGetPropertiesAsync(AsyncHandle)

Returns the identifier and the type of the object.

Because it is not mandatory to set all properties when you define an object, the method GetProperties may show properties that were not set. In that case, default values are given.

If the member delta is set to true in the request object, only the delta is retrieved.
(Inherited from GenericObject.)
Public methodGetPropertiesAsyncT(FuncResponse, T, AsyncHandle) (Inherited from GenericObject.)
Public methodGetScatterplot
Public methodGetScatterplotAsync
Public methodGetSnapshotObject

Returns the type of the object and the corresponding handle.

(Inherited from GenericObject.)
Public methodGetSnapshotObjectAsync(AsyncHandle)

Returns the type of the object and the corresponding handle.

(Inherited from GenericObject.)
Public methodGetSnapshotObjectAsyncT(FuncResponse, T, AsyncHandle)

Returns the type of the object and the corresponding handle.

(Inherited from GenericObject.)
Public methodGetTable
Public methodGetTableAsync
Public methodGetTextImage
Public methodGetTextImageAsync
Public methodGetTreemap
Public methodGetTreemapAsync
Public methodIndexOfDefPath(String)
Converts an existing path to its equivalent index value
(Inherited from GenericObject.)
Public methodIndexOfDefPath(String)
Converts existing paths to their equivalent index values
(Inherited from GenericObject.)
Public methodIndexOfDefPathAsync(String)
Converts an existing path to its equivalent index value asyncronously
(Inherited from GenericObject.)
Public methodIndexOfDefPathAsync(String)
Converts existing paths to their equivalent index values asyncronously
(Inherited from GenericObject.)
Public methodLink
Link master object
(Inherited from GenericObject.)
Public methodLinkAsync
Link master object
(Inherited from GenericObject.)
Public methodLock

* Locks all selected values of a specific field if the target (or handle ) is a field

* Locks selected values of a generic object if the target (or handle ) is a generic object

(Inherited from GenericObject.)
Public methodLockAsync

* Locks all selected values of a specific field if the target (or handle ) is a field

* Locks selected values of a generic object if the target (or handle ) is a generic object

(Inherited from GenericObject.)
Public methodPublish

Publishes a generic object.

This method applies only if running in server mode.
(Inherited from GenericObject.)
Public methodPublishAsync

Publishes a generic object.

This method applies only if running in server mode.
(Inherited from GenericObject.)
Public methodRangeSelectHyperCubeValues

Make range selections in measures.

This method applies to hypercubes. For example, bar charts, tables and scatter plots.
(Inherited from GenericObject.)
Public methodRangeSelectHyperCubeValuesAsync(String, IEnumerableNxRangeSelectInfo, IEnumerableInt32, Boolean, Boolean, AsyncHandle)

Make range selections in measures.

This method applies to hypercubes. For example, bar charts, tables and scatter plots.
(Inherited from GenericObject.)
Public methodRangeSelectHyperCubeValuesAsyncT(String, IEnumerableNxRangeSelectInfo, IEnumerableInt32, Boolean, Boolean, FuncResponse, T, AsyncHandle)

Make range selections in measures.

This method applies to hypercubes. For example, bar charts, tables and scatter plots.
(Inherited from GenericObject.)
Public methodResetMadeSelections

Resets all selections made in selection mode.

(Inherited from GenericObject.)
Public methodResetMadeSelectionsAsync

Resets all selections made in selection mode.

(Inherited from GenericObject.)
Public methodResumeLayout
(Inherited from GenericObject.)
Public methodSearchListObjectFor

Searches for a string in a list object.

This method applies to list objects (objects with one dimension).The search results can be displayed using the GetLayout method.
(Inherited from GenericObject.)
Public methodSearchListObjectForAsync(String, String, AsyncHandle)

Searches for a string in a list object.

This method applies to list objects (objects with one dimension).The search results can be displayed using the GetLayout method.
(Inherited from GenericObject.)
Public methodSearchListObjectForAsyncT(String, String, FuncResponse, T, AsyncHandle)

Searches for a string in a list object.

This method applies to list objects (objects with one dimension).The search results can be displayed using the GetLayout method.
(Inherited from GenericObject.)
Public methodSelectHyperCubeCells

Makes selections in multiple dimensions and measures.

This method applies to hypercubes, such as bar charts, tables and scatter plots.
(Inherited from GenericObject.)
Public methodSelectHyperCubeCellsAsync(String, IEnumerableInt32, IEnumerableInt32, Boolean, Boolean, AsyncHandle)

Makes selections in multiple dimensions and measures.

This method applies to hypercubes, such as bar charts, tables and scatter plots.
(Inherited from GenericObject.)
Public methodSelectHyperCubeCellsAsyncT(String, IEnumerableInt32, IEnumerableInt32, Boolean, Boolean, FuncResponse, T, AsyncHandle)

Makes selections in multiple dimensions and measures.

This method applies to hypercubes, such as bar charts, tables and scatter plots.
(Inherited from GenericObject.)
Public methodSelectHyperCubeValues

Selects some values in one dimension.

The values are identified by their element numbers.

This method applies to charts, tables and scatter plots.
(Inherited from GenericObject.)
Public methodSelectHyperCubeValuesAsync(String, Int32, IEnumerableInt32, Boolean, AsyncHandle)

Selects some values in one dimension.

The values are identified by their element numbers.

This method applies to charts, tables and scatter plots.
(Inherited from GenericObject.)
Public methodSelectHyperCubeValuesAsyncT(String, Int32, IEnumerableInt32, Boolean, FuncResponse, T, AsyncHandle)

Selects some values in one dimension.

The values are identified by their element numbers.

This method applies to charts, tables and scatter plots.
(Inherited from GenericObject.)
Public methodSelectListObjectAll

Selects all values of a field.

This method applies to list objects (objects with one dimension).
(Inherited from GenericObject.)
Public methodSelectListObjectAllAsync(String, Boolean, AsyncHandle)

Selects all values of a field.

This method applies to list objects (objects with one dimension).
(Inherited from GenericObject.)
Public methodSelectListObjectAllAsyncT(String, Boolean, FuncResponse, T, AsyncHandle)

Selects all values of a field.

This method applies to list objects (objects with one dimension).
(Inherited from GenericObject.)
Public methodSelectListObjectAlternative

Selects all alternative values in a specific field.

This method applies to list objects (objects with one dimension).If a field contains at least one selected value, the values that are neither selected nor excluded are alternatives values.
(Inherited from GenericObject.)
Public methodSelectListObjectAlternativeAsync(String, Boolean, AsyncHandle)

Selects all alternative values in a specific field.

This method applies to list objects (objects with one dimension).If a field contains at least one selected value, the values that are neither selected nor excluded are alternatives values.
(Inherited from GenericObject.)
Public methodSelectListObjectAlternativeAsyncT(String, Boolean, FuncResponse, T, AsyncHandle)

Selects all alternative values in a specific field.

This method applies to list objects (objects with one dimension).If a field contains at least one selected value, the values that are neither selected nor excluded are alternatives values.
(Inherited from GenericObject.)
Public methodSelectListObjectExcluded

Inverts the current selections in a specific field.

This method applies to list objects (objects with one dimension).
(Inherited from GenericObject.)
Public methodSelectListObjectExcludedAsync(String, Boolean, AsyncHandle)

Inverts the current selections in a specific field.

This method applies to list objects (objects with one dimension).
(Inherited from GenericObject.)
Public methodSelectListObjectExcludedAsyncT(String, Boolean, FuncResponse, T, AsyncHandle)

Inverts the current selections in a specific field.

This method applies to list objects (objects with one dimension).
(Inherited from GenericObject.)
Public methodSelectListObjectPossible

Selects all possible values of a list object.

This method applies to list objects (objects with one dimension).
(Inherited from GenericObject.)
Public methodSelectListObjectPossibleAsync(String, Boolean, AsyncHandle)

Selects all possible values of a list object.

This method applies to list objects (objects with one dimension).
(Inherited from GenericObject.)
Public methodSelectListObjectPossibleAsyncT(String, Boolean, FuncResponse, T, AsyncHandle)

Selects all possible values of a list object.

This method applies to list objects (objects with one dimension).
(Inherited from GenericObject.)
Public methodSelectListObjectValues

Makes single selections in dimensions.

This method applies to list objects only.
(Inherited from GenericObject.)
Public methodSelectListObjectValuesAsync(String, IEnumerableInt32, Boolean, Boolean, AsyncHandle)

Makes single selections in dimensions.

This method applies to list objects only.
(Inherited from GenericObject.)
Public methodSelectListObjectValuesAsyncT(String, IEnumerableInt32, Boolean, Boolean, FuncResponse, T, AsyncHandle)

Makes single selections in dimensions.

This method applies to list objects only.
(Inherited from GenericObject.)
Public methodSelectPivotCells
This method only applies to hypercubes that are not represented as straight tables. The parameter qMode in HyperCubeDef must be set either to P or K.

** Pivot table **

Makes selections in the top or left dimension cells of a pivot table or in the data matrix. Only expanded dimensions can be selected.

** Stacked table **

Makes selections in the left dimension cells of a stacked table or in the data matrix.

There is no top dimensions in a stacked table.

** Example of a pivot table **

(Inherited from GenericObject.)
Public methodSelectPivotCellsAsync(String, IEnumerableNxSelectionCell, Boolean, Boolean, AsyncHandle)
This method only applies to hypercubes that are not represented as straight tables. The parameter qMode in HyperCubeDef must be set either to P or K.

** Pivot table **

Makes selections in the top or left dimension cells of a pivot table or in the data matrix. Only expanded dimensions can be selected.

** Stacked table **

Makes selections in the left dimension cells of a stacked table or in the data matrix.

There is no top dimensions in a stacked table.

** Example of a pivot table **

(Inherited from GenericObject.)
Public methodSelectPivotCellsAsyncT(String, IEnumerableNxSelectionCell, Boolean, Boolean, FuncResponse, T, AsyncHandle)
This method only applies to hypercubes that are not represented as straight tables. The parameter qMode in HyperCubeDef must be set either to P or K.

** Pivot table **

Makes selections in the top or left dimension cells of a pivot table or in the data matrix. Only expanded dimensions can be selected.

** Stacked table **

Makes selections in the left dimension cells of a stacked table or in the data matrix.

There is no top dimensions in a stacked table.

** Example of a pivot table **

(Inherited from GenericObject.)
Public methodSetChildArrayOrder

Sets the order of the children in a generic object.

To change the order of the children in a generic object, the identifiers of all the children must be included in the list of the identifiers (in qIds).
(Inherited from GenericObject.)
Public methodSetChildArrayOrderAsync

Sets the order of the children in a generic object.

To change the order of the children in a generic object, the identifiers of all the children must be included in the list of the identifiers (in qIds).
(Inherited from GenericObject.)
Public methodSetFullPropertyTree

Sets the properties of:

* a generic object

* the children of the generic object

* the bookmarks/embedded snapshots of the generic object

If the SetFullPropertyTree method is asked to set some properties to a child that does not exist, it creates the child.The type of an object cannot be updated.
(Inherited from GenericObject.)
Public methodSetFullPropertyTreeAsync

Sets the properties of:

* a generic object

* the children of the generic object

* the bookmarks/embedded snapshots of the generic object

If the SetFullPropertyTree method is asked to set some properties to a child that does not exist, it creates the child.The type of an object cannot be updated.
(Inherited from GenericObject.)
Public methodSetProperties

Sets some properties for a generic object.

(Inherited from GenericObject.)
Public methodSetPropertiesAsync

Sets some properties for a generic object.

(Inherited from GenericObject.)
Public methodSuspendLayout
(Inherited from GenericObject.)
Public methodUnlink
Unlink master object
(Inherited from GenericObject.)
Public methodUnlinkAsync
Unlink master object
(Inherited from GenericObject.)
Public methodUnlock

* Unlocks all selected values of a specific field if the target (or handle ) is a field

* Unlocks selected values of a generic object if the target (or handle ) is a generic object

(Inherited from GenericObject.)
Public methodUnlockAsync

* Unlocks all selected values of a specific field if the target (or handle ) is a field

* Unlocks selected values of a generic object if the target (or handle ) is a generic object

(Inherited from GenericObject.)
Public methodUnPublish

Unpublishes a generic object.

This method applies only if running in server mode.
(Inherited from GenericObject.)
Public methodUnPublishAsync

Unpublishes a generic object.

This method applies only if running in server mode.
(Inherited from GenericObject.)
Top
Extension Methods
  NameDescription
Public Extension MethodCellAt
Returns the ISheetCell for the row / column
(Defined by SheetExtensions.)
Public Extension MethodCellFor
Returns the ISheetCell for the object
(Defined by SheetExtensions.)
Public Extension MethodCellsAt
Returns a list of ISheetCell for the row / column
(Defined by SheetExtensions.)
Public Extension MethodCreateFilterpane
Create a filter pane
(Defined by ClientExtension.)
Public Extension MethodCreateFilterpaneAsync
Create a filter pane
(Defined by ClientExtension.)
Public Extension MethodCreateListbox
Create a Listbox
(Defined by ClientExtension.)
Public Extension MethodCreateListboxAsync
Create a Listbox
(Defined by ClientExtension.)
Public Extension MethodDecorateSheetCell (Defined by BindingsExtensions.)
Public Extension MethodSingleUrl (Defined by UrlExtensions.)
Top
Properties
  NameDescription
Public propertyCells
Public propertyChildren
Childlist for the sheet
Public propertyColumns
Public propertyError
(Inherited from GenericObject.)
Public propertyExtendsId
(Inherited from GenericObject.)
Public propertyHandle
The handle of the Qlik Sense entity.
(Inherited from QixClassBase.)
Public propertyHasSoftPatches
(Inherited from GenericObject.)
Public propertyId
The id of the Qlik Sense entity.
(Inherited from QixClassBase.)
Public propertyInfo
(Inherited from GenericObject.)
Public propertyMeta
(Inherited from GenericObject.)
Public propertyNxInfo
Public propertyNxLayoutErrors
Public propertyNxSelectionInfo
Public propertyProperties
Public propertyRank
Public propertyRows
Public propertySelectionInfo
(Inherited from GenericObject.)
Public propertySession
The session this entity resides in.
(Inherited from QixClassBase.)
Public propertySheetMetaData
Public propertySuspendedLayout
Indicated that the subscriptions are suspended
(Inherited from GenericObject.)
Public propertyThumbnail
Public propertyType
The type of the Qlik Sense entity.
(Inherited from QixClassBase.)
Public propertyVersion
Top
Events
  NameDescription
Public eventChanged
This event fires every time the Qlik Sense entity needs to be updated due to changes in either selectionstate, data or entity properties
(Inherited from QixClassBase.)
Public eventClosed
This event fires when the Qlik Sense entity has been removed or deleted.
(Inherited from QixClassBase.)
Top
See Also