PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • Overview
  • Handling the Pivot Table control by programming
  • 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 the management of Pivot Table controls
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Handling a Pivot Table control by programming
Overview
A Pivot Table control can be handled by programming.
To handle a Pivot Table control by programming, WINDEV proposes the PVT functions.
This help page explains how to handle a Pivot Table control by programming.
Handling the Pivot Table control by programming

Coloring the values

From the popup 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.
By 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 event "Cell display".
For example:
// If the turnover is less than 500, displays the value in red
IF VAL_TO <= 500 THEN
VAL_TO.BackgroundColor = PastelRed
END
Versions 20 and later
Remark: You have the ability to customize the style of each cell element: color, font, background color, ... via several properties. For more details, see Properties associated with the values of a Pivot Table control.
New in version 20
Remark: You have the ability to customize the style of each cell element: color, font, background color, ... via several properties. For more details, see Properties associated with the values of a Pivot Table control.
Remark: You have the ability to customize the style of each cell element: color, font, background color, ... via several properties. For more details, see Properties associated with the values of a Pivot Table control.
Versions 19 and later

Adding a column or row title

By default, the rows or columns of a Pivot Table control have no title. You have the ability to add one with Libellé used on the header name.
For example:
  • Pivot Table not displaying a title:
  • Pivot Table with a title:
The following code is used:
// Initialize PVT_Stats
COL_Continent.Caption = "Continent"
COL_Country.Caption = "Country"
COL_Type_Vehicle.Label = "Vehicle
COL_OrderDate_Year.Caption = "Year"
COL_OrderDate_Quarter.Caption = "Quarter"
COL_OrderDate_Month.Caption = "Month"
New in version 19

Adding a column or row title

By default, the rows or columns of a Pivot Table control have no title. You have the ability to add one with Libellé used on the header name.
For example:
  • Pivot Table not displaying a title:
  • Pivot Table with a title:
The following code is used:
// Initialize PVT_Stats
COL_Continent.Caption = "Continent"
COL_Country.Caption = "Country"
COL_Type_Vehicle.Label = "Vehicle
COL_OrderDate_Year.Caption = "Year"
COL_OrderDate_Quarter.Caption = "Quarter"
COL_OrderDate_Month.Caption = "Month"

Adding a column or row title

By default, the rows or columns of a Pivot Table control have no title. You have the ability to add one with Libellé used on the header name.
For example:
  • Pivot Table not displaying a title:
  • Pivot Table with a title:
The following code is used:
// Initialize PVT_Stats
COL_Continent.Caption = "Continent"
COL_Country.Caption = "Country"
COL_Type_Vehicle.Label = "Vehicle
COL_OrderDate_Year.Caption = "Year"
COL_OrderDate_Quarter.Caption = "Quarter"
COL_OrderDate_Month.Caption = "Month"
Versions 19 and later

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 make a value invisible, all you have to do is use Visible.
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 code line in the initialization code of the Pivot Table control:
VAL_Qty.Visible = False
New in version 19

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 make a value invisible, all you have to do is use Visible.
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 code line in the initialization code of the Pivot Table control:
VAL_Qty.Visible = False

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 make a value invisible, all you have to do is use Visible.
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 code line in the initialization code of the Pivot Table control:
VAL_Qty.Visible = False
Versions 19 and later

Finding out and modifying the mask used to display values

To find out and modify the type displayed for a value of a Pivot Table control, use InputType. You can use the following syntax:
{{"Value Name"}}..InputType = typInputDuration
or:
ValueName.InputType = typInputDuration
New in version 19

Finding out and modifying the mask used to display values

To find out and modify the type displayed for a value of a Pivot Table control, use InputType. You can use the following syntax:
{{"Value Name"}}..InputType = typInputDuration
or:
ValueName.InputType = typInputDuration

Finding out and modifying the mask used to display values

To find out and modify the type displayed for a value of a Pivot Table control, use InputType. You can use the following syntax:
{{"Value Name"}}..InputType = typInputDuration
or:
ValueName.InputType = typInputDuration
Versions 19 and later

Modifying the axes displayed

You have the ability to modify the axes displayed or to reverse the rows and columns with PVTAxisXY.
Example:
// Modifies the rows and columns displayed
PVTAxisXY(PVT_Stats, "COL_Year" + CR + "COL_Quarter", "COL_VehicleType" + CR + "COL_Model")
New in version 19

Modifying the axes displayed

You have the ability to modify the axes displayed or to reverse the rows and columns with PVTAxisXY.
Example:
// Modifies the rows and columns displayed
PVTAxisXY(PVT_Stats, "COL_Year" + CR + "COL_Quarter", "COL_VehicleType" + CR + "COL_Model")

Modifying the axes displayed

You have the ability to modify the axes displayed or to reverse the rows and columns with PVTAxisXY.
Example:
// Modifies the rows and columns displayed
PVTAxisXY(PVT_Stats, "COL_Year" + CR + "COL_Quarter", "COL_VehicleType" + CR + "COL_Model")

Modifying the data source

You also have the ability to modify the data source of a Pivot Table control via BrowsedFile.
Example:
// Modifies the rows and columns displayed
PVT_Stats.BrowsedFile = 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.
  • Versions 20 and later
    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:
      PVT_Stats.BrowsedFile = ":MyNewStructure"
    New in version 20
    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:
      PVT_Stats.BrowsedFile = ":MyNewStructure"
    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:
      PVT_Stats.BrowsedFile = ":MyNewStructure"

Progress of calculation

  • A progress bar is displayed during the calculation of the Pivot Table control.
  • Versions 20 and later
    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:
    PROCÉDURE 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
    New in version 20
    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:
    PROCÉDURE 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
    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:
    PROCÉDURE 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 the management of Pivot Table controls

The following properties are used to manage the Pivot Table controls:
Versions 18 and later
Cumulated
New in version 18
Cumulated
Cumulated		The Property Cumul makes it possible to know if the value of a column or an row of an Pivot Table control corresponds to a total (end of row or end of column total).
Versions 18 and later
DisplayOrphan
New in version 18
DisplayOrphan
DisplayOrphan		The DisplayOrphan property is used to:
  • Find out whether a row or a column found in a Pivot Table control is displayed when it has no parent.
  • Modify the display mode of a row or column in a Pivot Table control when it has no parent.
Versions 18 and later
FilterProcedure
New in version 18
FilterProcedure
FilterProcedure		The 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.
Versions 18 and later
ProgressBar
New in version 18
ProgressBar
ProgressBar		The ProgressBar property is used to identify and change the Progress Bar control used when calculating a Pivot Table control (PVTCalculateAll and PVTCalculateUpdate functions).
To find out the entire list of WLanguage properties that can be used with a Pivot Table control, see Properties associated with the Pivot Table control.
See also
Minimum version required
  • Version 18
Comments
Click [Add] to post a comment