PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

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
Indicates the type of category in a Waterfall chart.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Versions 23 and later
PHP This function is now available for PHP sites.
New in version 23
PHP This function is now available for PHP sites.
PHP This function is now available for PHP sites.
Example
// TO 2017
CHART_Waterfall.AddData(1, 1, 298000)
CHART_Waterfall.CategoryLabel(1, "TO 2017")
 
// Add the profits
CHART_Waterfall.AddData(1, 2, 420000)
CHART_Waterfall.CategoryLabel(2, "Profits" + CR + "products")
CHART_Waterfall.AddData(1, 3, 210000)
CHART_Waterfall.CategoryLabel(3, "Profits" + CR + "services")
 
// Costs
CHART_Waterfall.AddData(1, 4, -170000)
CHART_Waterfall.CategoryLabel(4, "Fixed costs")
CHART_Waterfall.AddData(1, 5, -140000)
CHART_Waterfall.CategoryLabel(5, "Variable costs")
 
// TO 2018
CHART_Waterfall.AddData(1, 6, 0)
CHART_Waterfall.CategoryLabel(6, "TO 2018")
CHART_Waterfall.WaterfallCategoryType(6, grSubTotal)
 
// Cumulated TO
CHART_Waterfall.AddData(1, 7, 0)
CHART_Waterfall.CategoryLabel(7, "Cumulated TO")
CHART_Waterfall.WaterfallCategoryType(7, grTotal)
Syntax
<Chart control>.WaterfallCategoryType(<Category> , <Type of category>)
<Chart control>: Control name
Name of the Chart control in the window editor, report editor or page editor.
PHP Only the interactive Chart controls are available.
<Category>: Integer
Number of the category to use.
<Type of category>: Integer constant
Type of category:
grDefaultPositive or negative values of the chart.
grSubTotalSub-total values.
If the category corresponds to a sub-total, the value stored for this category is ignored. For this category, the Waterfall chart displays a bar corresponding to the sum of all previous categories from the last total or sub-total.
grTotalTotal values.
If the category corresponds to a total, the value stored for this category is ignored. For this category, the Waterfall chart displays a bar corresponding to the sum of all previous categories from the beginning of the chart.
Remarks
  • Special case: the first category
    The first category is always a "total" category but the specified value is displayed: it is the start value.
  • This function applies to the Waterfall charts only.
Related Examples:
WD Chart Training (WINDEV): WD Chart
[ + ] This educational example present different uses of the chart control.
The following charts are presented:
- Semi-circular
- Donut
- Pie
- Sunburst
- Line
- Scatter
- 3D Scatter
- Column
- Area
- Bubble
- Radar
- Funnel
- Surface
- Waterfall
- Composite

The main features presented in this example are the ability to customize the charts by programming as well as the method used to fill a chart from a HFSQL file or in the editor.
Component : wd240grf.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment