<Pivot table>.Select (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

WLanguage functions

Controls, pages and windows

Pivot Table functions

Prefix syntax

Select

Presentation

Example

See also

<Pivot table>.Select (Function)

In french: <Tableau croisé dynamique>.Select

Allows you find out the position of the selected cell and to select a cell in a Pivot Table control.

Example

// Get the current position
pvtPos is pvtPosition
pvtPos = PVT_Stats.Select()
IF NOT pvtPos.Out THEN
Trace(pvtPos.Country + " " + pvtPos.City)
END

// Loop through the selected cells
pvtPos is pvtPosition of PVT_MyPVT

nbSel is int = PVT_MyPVT.SelectCount()
FOR i = 1 TO nbSel
pvtPos = PVT_MyPVT.Select(i)
Trace(pvtPos.COL_Today_Date + ":" + pvtPos.COL_Product))
END

pvtPos is pvtPosition
// Select "France / 2014"
pvtPos.Country = "FRANCE"
pvtPos.Year = "2014"
PVT_Stats.Select(pvtPos)

Syntax

Retrieving the position of selected cell in a Pivot Table control Hide the details

<Result> = <Pivot Table control>.Select([<Rank>])

<Result>: pvtPosition variable

pvtPosition variable containing the position of selected cell in the control. If no element is selected, the Out property of the pvtPosition variable returned is set to True.

<Pivot Table control>: Control name

Name of the Pivot Table control to be used.

<Rank>: Optional integer

Rank of selection for a multi-selection control. If this parameter is not specified, the position of first selected cell is returned.

Selecting a position in a Pivot Table control Hide the details

<Pivot Table control>.Select(<Position> [, <Value>])

<Pivot Table control>: Control name

Name of the Pivot Table control to be used.

<Position>: pvtPosition variable

Name of the pvtPosition variable corresponding to the position to select. A WLanguage error occurs if the position does not correspond to a visible cell.

<Value>: Character string

Name of the value to select. If this parameter is not specified and if several values are found in the same cell, the first value is selected.

Component: wd280obj.dll