ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Pivot Table functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
<Pivot Table>.ListPositionHeader (Function)
In french: <Tableau croisé dynamique>.ListePositionEntête
Returns all values associated with a row or column header in a Pivot Table control.
Example
// Renvoie tous les pays affichés dans le champ Tableau croisé dynamique
tabPos is array of pvtPosition
tabPos = TCD_Statistiques.ListePositionEntête(COL_Pays)
FOR EACH dim OF tabPos
	// Affiche le total pour chaque pays si > 10000
	IF VAL_CA[dim] > 10000
		Trace(dim.Pays + " : " + VAL_CA[dim])
	END
END

// Renvoie toutes les villes affichées dans le champ Tableau croisé dynamique
tabPos = TCD_Statistiques.ListePositionEntête(COL_Ville)
FOR EACH dim OF tabPos
	// Trace les villes françaises
	IF (dim.Pays ~= "FRANCE") THEN
		Trace(dim.Ville)
	END
END
Syntax
<Result> = <Pivot Table control>.ListPositionHeader(<Header>)
<Result>: Array of pvtPosition
Array of pvtPosition variable containing the list of elements corresponding to the specified header.
<Pivot Table control>: Control name
Name of the Pivot Table control to be used.
<Header>: Character string
Name of the row or column header for which the different elements must be listed. This header must be visible and it must be displayed in the control.
Remarks
In the result array:
  • The headers of parents are filled.
  • The headers of children or other axes have "*" for value (.Cumulated = True).
The same value can be returned several times with a different parent. For example, if we want to retrieve the list of vehicle models per country, the same model can be used in several countries.
Component: wd300obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/20/2024

Send a report | Local help