ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

New WINDEV 2024 feature!
Help / WLanguage / WLanguage functions / Controls, pages and windows / Pivot Table functions
  • How is data calculated?
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
Entirely calculates or recalculates a Pivot Table control, without blocking the application.
Example
PVTCalculateAllAsynchronous(PVT_Statistics, Calculation_completed)
INTERNAL PROCEDURE Calculation_completed(bOK is boolean)
IF NOT bOK THEN
Error(ErrorInfo())
RETURN
END
END
Syntax
PVTCalculateAllAsynchronous(<Pivot Table control> [, <WLanguage procedure>])
<Pivot Table control>: Control name
Name of the Pivot Table control to calculate or recalculate.
<WLanguage procedure>: Optional procedure name
Name of the WLanguage procedure ("callback") called once the calculation is completed.
For more details on this procedure, see Parameters of the procedure used by PVTCalculateAllAsynchronous.
Remarks

How is data calculated?

Data is calculated by iterating over all the necessary records. This can take a long time depending on the size of the database. For example, calculating one million records can take several minutes. PVTCalculateAllAsynchronous does not block the application and executes the specified WLanguage procedure after the calculation is completed.
The content of the Pivot Table control must be entirely recalculated:
  • When adding new items.
  • When changing filter options.
  • When changing the source data.
The content of the Pivot Table control does not need to be entirely recalculated:
  • When using a filter on a dimension that is already calculated.
  • When changing dimension.
  • When expanding or collapsing a dimension (e.g. to display quarters instead of years).
Component: wd290obj.dll
Minimum version required
  • Version 2024
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 02/27/2024

Send a report | Local help