Chart
Kalipso - Developing - Form - Controls - Type - Chart
Last updated
Kalipso - Developing - Form - Controls - Type - Chart
Last updated
A Chart, also called a graph, is a graphical representation of data, in which the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart. Value - It has no value.
Common
Name - Name of the Control. This Name will be used to identify the Control throughout the Project. The name of the Control can only contain letters, digits or underscore (_).
Title - Title of the Control. The position may vary according to the Operating System.
Description - Not applicable to this control
Plane - Plane of the Form where the Control should be created. Check the Planes chapter for more information.
Visible - With this option selected, the control is (or is not) visible.
Enabled - With this option selected, the control is (or is not) enabled. It may be visible (previous option), but it may not be enabled. In this case an event associated with the control is not executed
Layout
X - x position of the Control from left
Y - y position of the Control from top
Width - Width of the Control.
Height - Height of the Control
In relation to all these layout options, it is possible to set this value in runtime via the “Set Property” Action. You can also retrieve this value in runtime via the “Get Property” Action.
Style
Appearance
Background - Background color of the Control. You can set the color for the background.
Opacity - Set the percentage of opacity for the background.
You can set this value is runtime via the “Set Property” Action. You can retrieve this value in runtime via the “Get Property” Action.
On the right side of the Style section, you can choose templates with pre-defined styles or configurable ones. By clicking on this option, the following style possibilities for the label appear:
Styles
None
Base
Text
Font - Font of the displayed Text
Size - Font size of the displayed Text
Color - Font color of the displayed Text
Properties - Font properties of the displayed Text (bold, italic, underline)
Border
Border - Yes or No
Scale
Font size - Sets the font size on a scale from 6 to 20.
Show Lines - Question whether or not lines appear on the chart
Step - Value of the intervals used in the Chart's scale.
In the step option you can leave empty for an automatic scale step.
Chart Type
Pie - A circle is divided into sectors that each represent a proportion of the whole.
Line - Displays information as a series of data points called 'markers', connected by straight line segments.
Bar - Presents grouped data with rectangular bars with lengths proportional to the values that they represent.
Multi Line - Line chart in which multiple data sets are represented by drawing the lines overlapped.
Multi Bar - Bar chart in which multiple data sets are represented by drawing the bars side by side in a cluster.
Load Control with
Database Table - The control will be linked to a Database Table and the number of records will be the same as the source Database Table. For the data to be displayed, "Refresh Control" Action must be called.
SQL Advanced - You're able to define the query that fills the control. The query should return a column for each link.
Choosing in load control with "Database Table" or "SQL Advanced" the options below in the window change to fit the type of option selected. In this way, for "Database Table" the Data Source for the Database Table the control will be linked to a Database Table and the number of records will be the same as the source Database Table.
For the data to be displayed, "Refresh Control" Action must be called.
In addition to the database table option, it can be configured using the following four possibilities:
Kalipso Syntax - A slightly different form of SQL. Everything remains the same but instead of single-quotes to enclosure string types, you should use double-quotes. When referring to Controls or Variables, quoting is not needed.
String Expression - A string expression who will be evaluated and the result is executed over the database. You are responsible by specifying a result with the syntax expected by the database. Quoting is also your responsibility.
Filter - "Where" clause to be applied in the "select" to the Database Table.
Order By - "Order By" to be applied in the "select" to the Database Table.
In addition to the SQL Advanced option, it can be configured using the following possibility:
Database Profile - Database connection over which the specified query should be executed. You only need to specify one if it's online.
Clicking on the white area at the three points opens a new window where you can add strings to the SQL being entered.
Color Column - If selected a column from the Database the value should be a Hexadecimal string with "#" ex: #2a9d8f
For each control, actions can be associated. For this, with the control selected, it is possible to access this tab and associate an action to the control. For more information on the actions available and how to use them click here.
F2 - Actions
F3 - General Properties
