Setter Name | Example | Description |
---|
setAxisWidth(int value) | GRAPHOMATETABLE_1.setAxisWidth(1); | Setzt eine neue Achsenbreite. |
setCollapsibleHierarchy(boolean value) | GRAPHOMATETABLE_1.setCollapsibleHierarchy(false); | Sets the visibility of the hierarchy control elements (+ and - before the line items). |
setColumnOrder(String value) | var neworder = '[{"identifier":"series1","position":2},{"identifier": "tableDeviations1","position":1},{"identifier":"series2","position":0}]' GRAPHOMATETABLE_1.setColumnOrder(neworder); | Sets the column order. |
setColumnTitleVisible(boolean value) | GRAPHOMATETABLE_1.setColumnTitleVisible(false); | Sets the visibility of the column titles: If the value is false, the column titles are hidden. |
setColumnWidth(int value) | GRAPHOMATETABLE_1.setColumnWidth(100); | This function sets the width of the columns. But it is only interpreted when fixedColumnWidth is set. |
setComparisonGroup(String id) | GRAPHOMATETABLE_1.setComparisonGroup("A"); | Sets the Comparison Group of the deviation charts in the table as a string. All charts in tables with the same Comparison Group are equal scaled and aligned. |
setDatatypes(String value) | GRAPHOMATETABLE_1.setDatatypes("AC,PP,BU"); | This function sets the Data Types for the entire table. Expects value as comma-separated string. |
setDeviationBadColor(String value) | GRAPHOMATETABLE_1.setDeviationBadColor("#FF0000"); | Sets the color of the negative deviations. |
setDeviationGoodColor(String value) | GRAPHOMATETABLE_1.setDeviationGoodColor("#00FF00"); | Sets the color for the positive deviations. |
setDeviationLabel(String id, String label) | GRAPHOMATETABLE_1.setDeviationLabel("deviation2", "Percent"); | Allows you to change the label of a deviation column. The ID of the column to be changed and the new label are expected as parameters of the method. The label of the respective column in the Property Deviations Config get changed. This is equivalent to changing the label from the Additional Properties Sheet. |
setDeviationLabels(String value) | GRAPHOMATETABLE_1.setDeviationLabels("Absolute,Percent"); | Sets new column headers for the deviations and changes the value of the Property Deviation Labels, which overwrites the column headers separately from the setting in the Additional Properties Sheet or the Standard Property Deviations Config. |
setDeviationVisibility(String name, boolean visible) | GRAPHOMATETABLE_1.setDeviationVisibility("abs", true); | Sets the visibility of the deviation definition with the label name. |
setExceptionPosition(String value) | GRAPHOMATETABLE_1.setExceptionPosition("leading"); | Sets the value for positioning the exceptions. Possible values are leading (at the beginning oft he cell), before and after the value. |
setExceptionVisibility(String name, boolean visible) | GRAPHOMATETABLE_1.setExceptionVisibility("good", true); | Sets the visibility of the Exception definition with the label name. |
setExpandTo(int value) | GRAPHOMATETABLE_1.setExpandTo(2); | Sets the hierarchy level up to which the hierarchy is to be expanded in the start drilldown (starting with level 0). In conjunction with setting the visibility of the control elements for the hierarchy (see collapsibleHierarchy ()) a restriction in the visibility is possible (see Examples). |
setExtendedNumberFormat(String value) | GRAPHOMATETABLE_1.setExtendedNumberFormat("-||.|,|1|1|"); | Sets the number format for the Extended Mode. The format string can be found in the manual. |
setExtendedNumberFormatPercentage(String value) | GRAPHOMATETABLE_1.setExtendedNumberFormatPercentage("-||.|,|1|1|%25"); | Sets the number format for the percentages in the Extended Mode. The format string can be found in the manual. |
setFilterString(String value) | GRAPHOMATETABLE_1.setFilterString("revenue$"); | Sets an initial text or regular expression into the filter in order to show a certain drilldown of the table at the start of the application. |
setFixedColumnWidth(boolean value) | GRAPHOMATETABLE_1.setFixedColumnWidth(true); | This functions sets whether the Column Width should be fixed. If it is not fixed, the width is determined automatically. |
setFixedHeader(boolean value) | GRAPHOMATETABLE_1.setFixedHeader(true); | This function sets whether the table header (column titles) are fix and therefore also visible while scrolling. |
setFontFamily(String value) | GRAPHOMATETABLE_1.setFontFamily("Comic Sans"); | Sets the font family. |
setHierarchyStates(String states) | GRAPHOMATETABLE_1.setHierarchyStates("EXPANDED,CLOSED,CLOSED“); | Allows you to set the status of the hierarchy. This allows you to expand and collapse nodes within the hierarchy. The method expects a string as a parameter that contains the substrings EXPANDED or CLOSED comma-separated for each row and thus determines for each row whether it is displayed expanded or closed. |
setLabelFormatMode(String value) | GRAPHOMATETABLE_1.setLabelFormatMode("extended"); | Sets a string value for the used label format mode. Available values are basic and extended. |
setLocale(String value) | GRAPHOMATETABLE_1.setLocale("de"); | Sets the value of the locale. Allowed values are: de, en, fr and auto. If auto is used, the locale from the query is used for formatting the data. |
setNegativeDeviationIsGood(boolean value) | GRAPHOMATETABLE_1.setNegativeDeviationIsGood(false); | This function sets whether negative deviations are shown as positive or negative. |
setNoClip(boolean value) | GRAPHOMATETABLE_1.setNoClip(false); | Sets the value for the noClip property. |
setNumberFormat(String value) | GRAPHOMATETABLE_1.setNumberFormat("0,0.0"); | Sets the number format for the Basic Mode. The format string corresponds to the format numeral.js (see http://www.numeraljs.com). |
setNumberFormatPercentage(String value) | GRAPHOMATETABLE_1.setNumberFormatPercentage("0 %"); | Sets the number format for the percentages in the Basic Mode. The format string corresponds to the format numeral.js (see http://www.numeraljs.com). |
setNumberFormatPerColumn(String value) | GRAPHOMATETABLE_1.setNumberFormatPerColumn('["","-||.|,|1|1|%25",""]'); | Enables the setting of an extended number format for each column. The array contains different format strings. Empty strings are ignored and the number format of the table is used. |
setRowTitleVisible(boolean value) | GRAPHOMATETABLE_1.setRowTitleVisible(false); | Sets the visibility of the row titles: If the value is false, the row titles are hidden. |
setSemanticAxis(boolean value) | GRAPHOMATETABLE_1.setSemanticAxis(true); | Sets whether semantic axis for the devitations are displayed. |
setSeries(int seriesIndex, String value) | GRAPHOMATETABLE_1.setSeries(1, '{"Keyfigures":"0D_NWI_NSAL"}'); | Set the data description of the selected Data Series seriesIndex. Expects value as JSON string. This string either describes a row or a column in the Initial View. The string can be read out after data for a Data Series has been selected on the Property Sheet with the graphomate tables extension. |
setSeriesLabels(String value) | GRAPHOMATETABLE_1.setSeriesLabels("Oct,Nov"); | Sets the column titles of the data series. |
setShowDeviationLabels(boolean value) | GRAPHOMATETABLE_1.setShowDeviationLabels(true); | Sets whether the values of the deviations are displayed. |
setShowHierarchy(boolean value) | GRAPHOMATETABLE_1.setShowHierarchy(true); | Sets whether the row titles are displayed in a hierarchical structure. |
setShowScalingFactor(boolean value) | GRAPHOMATETABLE_1.setShowScalingFactor(true); | Sets whether the scaling factor (coming from the Designer settings) is displayed. |
setShowTitle(boolean value) | GRAPHOMATETABLE_1.setShowTitle(true); | Sets whether the title is displayed. |
setShowUnits(boolean value) | GRAPHOMATETABLE_1.setShowUnits(true); | Sets whether the units (coming from the query) are displayed below the column title. |
setSumBorders(boolean value) | GRAPHOMATETABLE_1.setSumBorders(true); | Sets whether Sum Borders are displayed. |
setSumBorderColor(String value) | GRAPHOMATETABLE_1.setSumBorderColor("#00FFCC"); | Sets the color of the Sum Borders. |
setSumBorderThickness(float value) | GRAPHOMATETABLE_1.setSumBorderThickness(0.2); | Sets the thickness of the Sum Borders. |
setSumPadding(float value) | GRAPHOMATETABLE_1.setSumPadding(0.3); | Sets the padding between the sums and the corresponding child elements. |
setSuppressZeroLabels(boolean value) | GRAPHOMATETABLE_1.setSuppressZeroLabels(true); | Sets whether zero values are displayed in the table. |
setTextualDeviation(boolean value) | GRAPHOMATETABLE_1.setTextualDeviation(true); | Sets whether textualDeviation is active. If it is true, no deviation charts are displayed, but the values are represented as numbers. |
setTitle(String value) | GRAPHOMATETABLE_1.setTitle("Sales in Mio. EUR|2013 ACT and BUD|North West"); | Sets the title of the table. Expects value as a string. Line breaks (\n) are interpreted as such. |
setUseFormattedData(boolean value) | GRAPHOMATETABLE_1.setUseFormattedData(true); | Sets whether the preformatted data from Designer is used for the entries of the table. This is possible only for the values that are passed from the query. Values, which are calculated in the table itself, eg for the deviations, are formatted still either in the basic or extended number format. |
setUserHighlightColor(String value) | GRAPHOMATETABLE_1.setUserHighlightColor("red,#00ff00,#0000ff"); | Sets a list of disposited colors for the User Highlights. Expects a comma separated string-value. The colors of the list are switched at each click (during runtime) until the desired color is set. |
setUserHighlightList(String value) | GRAPHOMATETABLE_1.setUserHighlightList("[[1,3],[2,3][1,5]]"); | Sets the list of user highlights (highlighted values at runtime). Expects a JSON-string consisting of one or more arrays with two numbers; the first number indicates the data row, while the second number represents the position of the value in the data series. |
setWidthPerColumn(String val) | GRAPHOMATETABLE_1.getWidthPerColumn("[100,300,0,\"max200\"]"); | Sets the Width Per Column-property to the given value. |
setFontSize(...) | GRAPHOMATETABLE_1.setFontSize(15); | Sets the font size to the passed value. |
setNoClip(...) | GRAPHOMATETABLE_1.setNoClip(true); | The setting of the property prevents the pots of the percentage deviations on the axis from being cut off. This will result in a less readable version, but will prevent a bug that may otherwise occur with Safari. |
setZeroValueReplacement(...) | GRAPHOMATETABLE_1.setZeroValueReplacement("-"); | The passed string is displayed instead of 0 values. |
setInfinityValueReplacement(...) | GRAPHOMATETABLE_1.setInfinityValueReplacement("~"); | The passed string is displayed instead of infinity values. |
setEmptyValueReplacement(...) | GRAPHOMATETABLE_1.setEmptyValueReplacement("¯\_(ツ)_/¯"); | The passed string is displayed instead of null values. |
setShowHeatmap(...) | GRAPHOMATETABLE_1.setShowHeatmap(true); | Ensures that the heatmap representation of the table is switched on or off. |
setHeatmapColScale(...) | GRAPHOMATETABLE_1.setHeatmapColScale("Blues,5"); | Sets the color scheme of the heat map. |
setIncellColumns(...) | GRAPHOMATETABLE_1.setIncellColumns("[\"series1\",\"series2\"]"); | Specifies the columns that should have In Cell Charts. |
setIncellBarHeightFactor(...) | GRAPHOMATETABLE_1.setIncellBarHeightFactor(0.5); | Sets the factor used to calculate the height of the bars in the In Cell Charts. |
setIncellBarOpactiy(...) | GRAPHOMATETABLE_1.setIncellBarOpactiy(0.1); | Sets the opacity of the bars of the In Cell Charts. |
setIncellPositiveColor(...) | GRAPHOMATETABLE_1.setIncellPositiveColor("#0000ff"); | Sets the color of the positive bars of the In Cell Charts. |
setIncellNegativeColor(...) | GRAPHOMATETABLE_1.setIncellNegativeColor("#00ff00"); | Sets the color of the negative bars of the In Cell Charts. |
setUseOutlierThreshold(...) | GRAPHOMATETABLE_1.setUseOutlierThreshold(false); | Determines whether to use the Outlier Threshold. |
setOutlierThreshold(...) | GRAPHOMATETABLE_1.setOutlierThreshold(5000000); | Sets the Outlier Threshold for absolute values. |
setOutlierThresholdPercent(...) | GRAPHOMATETABLE_1.setOutlierThresholdPercent(0.5); | Sets the Outlier Threshold for percentage values. |
setIbcsPinHeads(...) | GRAPHOMATETABLE_1.setIbcsPinHeads(true); | Represents the pin heads of the percentage deviations according to the IBCS. |
setApplyPinColor(boolean applyPinColor) | GRAPHOMATETABLE_1.setApplyPinColor(true); | Sets whether the manual pin color should be applied. If false, the good or bad color will be applied. |
setApplyPinHeadColor(boolean applyPinHeadColor) | GRAPHOMATETABLE_1.setApplyPinHeadColor(true); | Sets whether the manual pin head color should be applied. If false, the good or bad color will be applied. |
setApplyDataTypesToCells(boolean applyDataTypesToCells) | GRAPHOMATETABLE_1.setApplyDataTypesToCells(true); | Sets whether the data types should be applied to the columns' cells. |
setContextMenuAvailable(boolean contextMenuAvailable) | GRAPHOMATETABLE_1.setContextMenuAvailable(true); | Sets whether the context menu is available via right click. |
setDeviationLabelSizeFactor(float deviationLabelSizeFactor) | GRAPHOMATETABLE_1.setDeviationLabelSizeFactor(0.7); | Sets the deviation label font size factor. |
setDataCellAlignmentRight(boolean dataCellAlignmentRight) | GRAPHOMATETABLE_1.setDataCellAlignmentRight(true); | Sets whether the text of data cells is aligned right. |
setDeviationsFromNull(boolean deviationsFromNull) | GRAPHOMATETABLE_1.setDeviationsFromNull(true); | Sets whether NULL values are interpreted as zero values (0) for deviation calculations. |
setExceptionsFromNull(boolean exceptionsFromNull) | GRAPHOMATETABLE_1.setExceptionsFromNull(true); | Sets whether NULL values are interpreted as zero values (0) for exception calculations. |
setExceptionFillNoneInTextColor(boolean exceptionFillNoneInTextColor) | GRAPHOMATETABLE_1.setExceptionFillNoneInTextColor(true); | Sets whether the color of exception symbols with a fill type of 'none' should be used for coloring the cells' text instead of its background. |
setShowFilterHelper(boolean showFilterHelper) | GRAPHOMATETABLE_1.setShowFilterHelper(true); | Sets the visibility of the filter helper input box. |
setHorizontalGridLineThickness(float thickness) | GRAPHOMATETABLE_1.setHorizontalGridLineThickness(0.1); | Sets the thickness of horizontal grid lines in em. |
setHighlightThickness(float thickness) | GRAPHOMATETABLE_1.setHighlightThickness(2); | Sets the thickness of user highlight borders in px. |
setHierarchyIndent(float hierarchyIndent) | GRAPHOMATETABLE_1.setHierarchyIndent(1.2); | Sets the size of the hierarchy indent in em. |
setManualScalePercentMax(float max) | GRAPHOMATETABLE_1.setManualScalePercentMax(50); | Sets the manual maximal value of the percentage scale. |
setManualScalePercentMax(float min) | GRAPHOMATETABLE_1.setManualScalePercentMax(-50); | Sets the manual minimal value of the percentage scale. |
setNodeStyleBold(boolean bold) | GRAPHOMATETABLE_1.setNodeStyleBold(true); | Sets whether the hierarchy nodes are styled using bold or normal font weight. |
setNoWrap(boolean noWrap) | GRAPHOMATETABLE_1.setNoWrap(true); | Sets whether the row title texts should be prevented from wrapping when they are too long. |
setNodeStyleItalic(boolean italic) | GRAPHOMATETABLE_1.setNodeStyleItalic(true); | Sets whether the hierarchy nodes are styled using italic or normal font style. |
setRemoveRepeatedLabels(boolean removeRepeatedLabels) | GRAPHOMATETABLE_1.setRemoveRepeatedLabels(true); | Sets whether repeating dimension members across the columns should only show up at the column of their first occurrence. |
setRowTitleAlignmentRight(boolean rowTitleAlignmentRight) | GRAPHOMATETABLE_1.setRowTitleAlignmentRight(true); | Sets whether the row title texts are aligned right. |
setShowHorizontalGridLines(boolean visible) | GRAPHOMATETABLE_1.setShowHorizontalGridLines(true); | Sets the visibility of the horizontal grid lines. |
setShowDataTypesInHeader(boolean showDataTypesInHeader) | GRAPHOMATETABLE_1.setShowDataTypesInHeader(true); | Sets whether the column headers should contain horizontal bars styled by their data type. |
setOutlierMode(String outlierMode) | GRAPHOMATETABLE_1.setOutlierMode("short"); | Sets a string representing the outlier mode. |
setUseHierarchyMarker(boolean useHierarchyMarker) | GRAPHOMATETABLE_1.setUseHierarchyMarker(true); | Sets the value of the property 'Use Hierarchy Marker'. If this property is set to true only the Hierarchy Marker (+/-) can be used to open or close hierarchy levels. Otherwise (set to false) the user may also click on the row title to open or close hierarchy levels. |
setUseHierarchyStates(boolean useHierarchyStates) | GRAPHOMATETABLE_1.setUseHierarchyStates(true); | Sets the value of the property 'Use Hierarchy States'. This property is used to switch between the usage of 'Hierarchy States' and 'Expand To', as otherwise the properties may contradict each other. |
setShowHeaderDimensions(String visibleHeaderDimensionIndices) | GRAPHOMATETABLE_1.setShowHeaderDimensions("1,3"); | Sets a string containing a comma separated list of integer values. Each value is an index of a column header dimension level. All header dimension texts addressed by an index of this list are meant to be visible while the other ones aren't displayed. A value of '' leads to all dimensions being visible. |
setVisibleSeries(String value) | GRAPHOMATETABLE_1.setVisibleSeries("2,3"); | Sets a comma separated list of the visible data series indices. The indices are 1-based. |
setSaveSelectedMemberOnRightClick(boolean saveSelectedMemberOnRightClick) | GRAPHOMATETABLE_1.setSaveSelectedMemberOnRightClick(true); | Sets whether a right click stores member information of the clicked cell retrievable by using the script method getSelectedMember. |
setContextMenuCustomEventVisibility(int index, boolean visibility) | GRAPHOMATETABLE_1.setContextMenuCustomEventVisibility(1, true) | Sets the visibility of a specified custom event in the Context Menu. |
setContextMenuCustomEventName(int index, String name) | GRAPHOMATETABLE_1.setContextMenuCustomEventName(1, "My Custom Event") | Sets the name of a specified custom event in the Context Menu. |
setContextMenuOptionVisibility(int index, boolean visibility) | GRAPHOMATETABLE_1.setContextMenuOptionVisibility(1, true) | Sets the visibility of a specified option in the Context Menu. Use the following indices to access the options: 1 for Sorting, 2 for Filters, 3 for Context Sensitive Filters, 4 for Filter and Hide, 5 for Clear Filters, 6 for Drilldown, 7 for Drillup, 8 for Zero Display, 9 for Member Display, 10 for Position of Totals, 11 for Total Display. |
hide() | GRAPHOMATETABLE_1.hide() | An alternative to setVisible(false), which hides the table in a more performant way. The component gets hidden using CSS and does not need to be re-rendered after getting shown again. However, this can result in the table not reflecting possible changes that occurred while it was hidden. |
show() | GRAPHOMATETABLE_1.show() | A table that was hidden by using the method hide() can only be displayed again with the help of this method. |