Introduction to Selectors Functionality

Selectors

Selectors are probably the most powerful components of all. Their overall functionality lets you create models with multiple selections. When you combine a selector with another component, for example a chart, the result is a powerful, dynamic model that is both elegant and easy to create.

Available selectors:

One of the most important characteristics of Crystal Xcelsius™ is how easy it is to create a model using selectors.  Typically, to use selectors you would need to create or use a program that is not easy to understand. At a minimum, you would need some programming skills. With Crystal Xcelsius™, you will be surprised at two things: How easy it is to use, and how powerful your models will be. 

In this section, we will explain the main functionality of the Crystal Xcelsius™ selectors.  For your convenience, we have created a series of self-running animations describing each selector's functionality. These animations are available on the Property Window of each selector. Just bring up the property window for the component and then click on the icon. The animation will run automatically.

 

Selectors Functionality

Selector behaviors included in Crystal Xcelsius™:

Recommended Use: Use the Position function when working with Excel Lookup functions or when using Excel What-if formulas.

Recommended Use: Use the label function when working with Excel Lookup functions or when using Excel What-if formulas.

Recommended Use:  Use the Value function to display a single cell that contains one value for each selector item. You can then use other components, for example a Value component, to display the selected value. The value will change with each selection.

Recommended Use:  Use the row function in models that contain data categorized in rows, in models where you use dynamic charts, or in models where the selector contains more than one cell of data.

Recommended Use:  Use the column function in models that contain data categorized in columns, in models where you use dynamic charts, or in models where the selector contains more than one cell of data.

Recommended Use: Use the status list to display different charts or other components that are visible or invisible according to the selector selection.

 

The following table describes the functions or behavior that apply to each selector: