AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Este contenido se ha traducido automáticamente.  Haga clic aquí  para ver la versión en inglés.
Ayuda / WLanguage / Funciones WLanguage / Controles, páginas y ventanas / Funciones Tabla dinámica
  • Implementation
WINDEV
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
Enables or disables a filter on a Pivot Table control.
Warning: Only a filter defined in the "Content" tab of the Pivot Table control description window can be used. When PVTFilter is used, only the display of the Pivot Table control is modified, the different totals are not updated.
Ejemplo
// -- Selecting a row of COMBO_Filter_by_family
// Filters the Pivot Table control on the family of products that must be taken into account
PVTFilter(PVT_Statistics, COL_Caption, MySelf)
IF PVT_Statistics.Count = 0 THEN
STC_NO_DATA.Visible = True
ELSE
STC_NO_DATA.Visible = False
END
Sintaxis
PVTFilter(<Pivot Table control> , <Display filter> , <Value>)
<Pivot Table control>: Control name
Name of the Pivot Table control to be used.
<Display filter>: Character string
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.
Observaciones

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. Filtering by family allows you 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
Clasificación Lógica de negocio / UI: Código UI
Componente: wd300obj.dll
Versión mínima requerida
  • Versión 18
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 27/03/2025

Señalar un error o enviar una sugerencia | Ayuda local