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.
Example
// TO 2017
grAddData(CHART_Waterfall, 1, 1, 298000)
grCategoryLabel(CHART_Waterfall, 1, "TO 2017")
 
// Add the profits
grAddData(CHART_Waterfall, 1, 2, 420000)
grCategoryLabel(CHART_Waterfall, 2, "Profits" + CR + "products")
grAddData(CHART_Waterfall, 1, 3, 210000)
grCategoryLabel(CHART_Waterfall, 3, "Profits" + CR + "services")
 
// Costs
grAddData(CHART_Waterfall, 1, 4, -170000)
grCategoryLabel(CHART_Waterfall, 4, "Fixed costs")
grAddData(CHART_Waterfall, 1, 5 -140000)
grCategoryLabel(CHART_Waterfall, 5, "Variable costs")
 
// TO 2018
grAddData(CHART_Waterfall, 1, 6, 0)
grCategoryLabel(CHART_Waterfall, 6, "TO 2018")
grWaterfallCategoryType(CHART_Waterfall, 6, grSubTotal)
 
// Cumulated TO
grAddData(CHART_Waterfall, 1, 7, 0)
grCategoryLabel(CHART_Waterfall, 7, "Cumulated TO")
grWaterfallCategoryType(CHART_Waterfall, 7, grTotal)
Syntax
grWaterfallCategoryType(<Chart name> , <Category> , <Type of category>)
<Chart name>: Character string (with or without quotes)
Name of chart to use. This name corresponds to:
  • the chart name defined by programming with grCreate.
  • the name of the Chart control found in the window editor, report editor or page editor.
<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 19
This page is also available for…
Comments
Click [Add] to post a comment