AX1685
RangeSlider refresh variable
RangeSlider refresh variables prompt users to select top and bottom values within a defined range, using slider handles. The selected values are written back to the data source, where they can be used to impact data queries or other aspects of a report.
For example, you can use the range slider variable to prompt users to select the top and bottom values of a price range. The report can then be filtered to only bring in rows where the price falls within that range.
Axiom Financial Institutions Suite supports two types of variables that use slider handles. If you want users to be able to select a single value instead of a range, use a Slider refresh variable instead.
Variable behavior
The variable displays as a bar with two slider handles. The user can slide the handles along the bar to select a top value and a bottom value, within the overall defined range of values.
Desktop Client: Example Range Slider refresh variable
Web Client: Example Range Slider refresh variable
As a handle slides across the bar, the values show in a tooltip so that users can see the available values between the labeled tick marks (if applicable).
Variable properties
This section explains how to complete a variable row in the RefreshVariables data source when defining a Range Slider variable. Some data source columns do not apply in this case and are not discussed here. If these inapplicable columns are present in the data source, they should be left blank on rows that define Range Slider variable types. If you are using the Data Source Assistant to complete the variable properties, then only the applicable columns will be shown in the task pane.
For more information on the RefreshVariables data source in general, see Defining refresh variables.
General variable properties
All refresh variables use a common set of general properties such as the variable name, display name, and whether the variable is enabled or required. Any special considerations for Calendar variables are noted.
| Column Tag | Description |
|---|---|
|
[Name] |
(missing or bad snippet) |
|
[DisplayName] |
(missing or bad snippet) |
|
[VariableType] |
Specifies the variable type. Enter |
|
[IsEnabled] |
(missing or bad snippet) |
|
[SelectedValue] |
The user's selected values for the variable are placed in this cell. For RangeSlider variables, the selected bottom and top values are separated with a semicolon. For example, if the user selects 10 and 50, these values are written as 10;50. NOTE: The combined range slider values are written back to the sheet as a string. This means that the numbers are preceded by a single quotation mark within the cell—for example: When setting up the file to use the variable value, point your formulas to this cell. (missing or bad snippet) |
|
[IsRequired] |
This option does not apply to RangeSlider variables and will be ignored. Technically, there is no way to clear the slider, as the slider handles are always on values within the range. When a user applies the variable, the current values are written back as the selected value, even if the user has not interacted with the slider. |
|
[DependsOn] |
(missing or bad snippet) |
|
[DefaultValueonOpen] |
(missing or bad snippet) The slider starts at the combination of the minimum and maximum values if no default value is defined. |
|
[ClearSelectedValueonSave] |
(missing or bad snippet) |
|
[ClearSelectedValueonOpen] |
(missing or bad snippet) |
|
[GroupName] |
(missing or bad snippet) |
|
[CollapseOnOpen] |
(missing or bad snippet) |
Variable-specific properties
The following additional properties apply to Range Slider variable types:
| Column Tag | Description |
|---|---|
|
[MinValue] |
The minimum value for the slider bar. This value defines the smallest number that can be selected on the slider. The left slider handle starts at the minimum value if no default value is specified. |
|
[MaxValue] |
The maximum value for the slider bar. This value defines the largest number that can be selected on the slider. The right slider handle starts at the maximum value if no default value is specified. |
|
[StepFrequency] |
Optional. The frequency of step values within the range. For example, if the range is 0 to 100 and you specify a step frequency of 10, then step values are available at 0, 10, 20, and so on. The slider handles snap to step values, so the step frequency determines which values the user can select within the range. The slider bar shows up to seven major tick marks with step values. All other steps are shown using minor tick marks, with the values visible in a tooltip as the user slides a handle.
Example range slider tooltip If the step frequency is not specified, then by default the range is divided evenly into 50 step values. |
|
[DisplayFormat] |
(missing or bad snippet) |
The following properties do not apply to RangeSlider variables: PlaceHolderText, ListChoices, ColumnName, AdditionalColumns, ColumnFilter, AllowMultiSelect, DataSourceName, DisplayFormat, Hierarchies, UseAsQuickFilter, TooltipColumn, PrimaryTable, LimitColumn, AutoQuoteString, MinDate, MaxDate.
Example data source
The following screenshot shows an example RangeSlider variable. The Selected Value field is populated to show what the values look like in the spreadsheet after the user selection.
