PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • Implementation
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Enables or disables a filter on a Pivot Table control.
Caution: Only a filter defined in the "Content" tab of the description window of Pivot Table control can be used. When PVTFilter is used, only the display of the Pivot Table control is modified, the different totals are not updated.
Example
// -- Sélection d'une ligne de COMBO_Filtrer_par_famille
// Filtre le champ Tableau croisé dynamique sur la famille des produits dont on doit tenir compte
PVTFilter(TCD_Statistiques, COL_Libellé, MySelf)
 
IF TCD_Statistiques.Occurrence = 0 THEN
LIB_AUCUNE_DONNEES.Visible = True
ELSE
LIB_AUCUNE_DONNEES.Visible = False
END
Syntax
PVTFilter(<Pivot Table control> , <Display filter> , <Value>)
<Pivot Table control>: Control name
Name of Pivot Table control to use.
<Display filter>: Character string (with or without quotes)
Name of display filter to use. This filter was defined in the "Content" tab of the description window of Pivot Table control.
<Value>: Type corresponding to the filter
  • Value of filter to implement.
  • Empty string ("") to delete the filter.
Remarks

Implementation

To implement a filter in a Pivot Table control, you must::
  1. Create the Pivot Table control.
  2. In the description window of Pivot Table control, in the "Content" tab, add one or more display filters.
  3. Create a control allowing the user to select the value of filter. The selection of value will run PVTFilter.
Example:
A Pivot Table control is defined to display sales statistics:
Pivot table for sales statistics
A filter is defined on the caption of family of products. The filter by family is used to only take into account the family specified in the calculation of turnovers.
Definition of filter
The window proposes a combo box allowing the user to choose the family of products to filter:
Choosing the family of products
Related Examples:
WD PivotTable Training (WINDEV): WD PivotTable
[ + ] This example presents the use of the Pivot Table control.

This Pivot Table control is used to display dynamic statistics while grouping the data.
These statistics are calculated form the database.
Component: wd270obj.dll
Minimum version required
  • Version 18
This page is also available for…
Comments
Click [Add] to post a comment