ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Pivot Table control
  • Overview
  • Manipulating Pivot Table controls programmatically
  • Coloring the values
  • Adding a column or row title
  • Making a value invisible
  • Finding out and modifying the mask used to display values
  • Modifying the axes displayed
  • Modifying the data source
  • Progress of calculation
  • Properties specific to Pivot Table controls
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Manipulating Pivot Table controls programmatically
Overview
A Pivot Table control can be handled programmatically.
To manipulate a Pivot Table control through programming, WINDEV proposes the PVT functions.
This help page explains how to programmatically manipulate Pivot Table controls.
Manipulating Pivot Table controls programmatically

Coloring the values

From the context menu of the Pivot Table control, the end user can easily color a value in order to highlight it. For more details, see Automatic features of Pivot Table controls.
Through programming, you have the ability to access the values in order to modify their style (text or background color, ...). To do so, modify the properties of values in the "Cell display" event.
For example:
// Si le CA est inférieur à 500, affiche la valeur en rouge
IF VAL_CA <= 500 THEN
	VAL_CA.CouleurFond = PastelRed
END
Note: You can customize the style of each cell element: color, font, background color, etc., using a number of properties.. For more details, see Properties associated with the values of a Pivot Table control.

Adding a column or row title

By default, the rows or columns of a Pivot Table control have no title. You can add one using the Caption property the header name.
For example:
  • Pivot Table not displaying a title:
  • Pivot Table with a title:
The following code is used:
// Initialisation de TCD_Stats
COL_Continent.Libellé = "Continent"
COL_Pays.Libellé = "Pays"
COL_Type_Véhicule.Libellé = "Véhicule"
COL_DateCommande_Année.Libellé = "Année"
COL_DateCommande_Trimestre.Libellé = "Trimestre"
COL_DateCommande_Mois.Libellé = "Mois"

Making a value invisible

By default, all the values of a Pivot Table are displayed. In some cases, it may be interesting to calculate the values but not to display them. The values exist in the Pivot Table control and they can be used to perform a calculation or to fill a chart for example, ...
To hide a value, simply use the Visible property.
Example: A Pivot Table displays in each cell the turnover and the quantity sold. A chart is built from the quantity sold and this quantity must not be displayed in the Pivot Table control. To do so, use the following line of code in the initialization code of the Pivot Table control:
VAL_Qté.Visible = False

Finding out and modifying the mask used to display values

To get and set the type displayed for a value in a Pivot Table control, use the InputType property. You can use the following syntax:
{{"Nom Valeur"}}..TypeSaisie = typSaisieDurée
or:
NomValeur.TypeSaisie = typSaisieDurée

Modifying the axes displayed

You have the ability to modify the axes displayed or to reverse the rows and columns with PVTAxisXY.
Example:
// Modifie les lignes et les colonnes affichées
PVTAxisXY(TCD_Stats, "COL_Année" + CR + "COL_Trimestre", "COL_TypeVéhicule" + CR + "COL_Modèle")

Modifying the data source

You also have the ability to modify the data source of a Pivot Table control via BrowsedFile.
Example:
// Modifie les lignes et les colonnes affichées
TCD_Stats.FichierParcouru = Stat2015
Caution:
  • If the Pivot Table control is based on a data file, the new source data file must have the same structure as the file used when creating the control.
  • If the Pivot Table control is based on an array of structures:
    • the new source array of structures must have the same structure as the variable used when creating the control.
    • the name of the new structure must be preceded by ":". For example:
      TCD_Stats.FichierParcouru = ":MaNouvelleStructure"

Progress of calculation

  • A progress bar is displayed during the calculation of the Pivot Table control.
  • The user has the ability to cancel the calculation via a "Cancel" button.
    To find out whether the calculation was entirely performed, use the ErrorOccurred variable.
    Example:
    PROCEDURE Load_PVT()
    
    PVTCalculateAll(PVT_Statistics)
    IF ErrorOccurred = True THEN
    	SWITCH Dialog("Do you want to cancel the current process?")
    		// Cancel
    		CASE 1
    			Close()
    		// Continue
    		CASE 0
    			Load_PVT()
    	END
    END

Properties specific to Pivot Table controls

The following properties are used to manage Pivot Table controls:
AutoLineWrapThe AutoLineWrap property is used to:
  • determine if the automatic line wrap feature is enabled in a multiline Edit control, in a column of a Table or TreeView control or in a row header of a Pivot Table control.
  • set the line wrap mode in a multiline Edit control, in a column of a Table or TreeView control or in a row header of a Pivot Table control.
CumulatedThe Cumulated property determines whether the value of a column or row in a Pivot Table control corresponds to a total (total at the end of a row or column).
DisplayOrphanThe property AfficheOrphelin property allows you to:
  • Determine whether a row or column in a Pivot Table control is displayed when it has no parent.
  • Change the display mode of a row or column in a Pivot Table control when it has no parent.
FilterProcedureThe FilterProcedure property allows you to get and modify the procedure used to apply a filter on a row or column header when calculating a Pivot Table control.
ProgressBarThe ProgressBar property is used to identify and change the Progress Bar control used when calculating a Pivot Table control (PVTCalculateAll and PVTCalculateUpdate functions).
For a complete list of WLanguage properties that can be used with Pivot Table controls, see Pivot Table control properties.
Minimum version required
  • Version 18
Comments
Click [Add] to post a comment

Last update: 09/21/2024

Send a report | Local help