- About Quantrix
- Solutions
- Products
- Services
- Sample Models
- Learning
- Learning Overview
- Video Demos
- Webinar Series
- Quick Guide
- User Guides
- Modeler Notes
- Mortgage Modification Modeler Note
- Election Tax Model
- Marketing Response Curve Model
- Pivoting Data
- Quantrix in Corporate Budgeting
- Using Expressions in Quantrix
- Performing a Sales Analysis
- Indirect() w/Capex & Depreciation
- Analyzing ARM vs. Fixed Mortgages
- Integrated Financials Models
- Leveraging the @ and # Operators
- Using Circular References
- Converting Spreadsheets to Quantrix
- Using Functions with Black-Scholes
- Using Statistical Functions
- Using Quantrix in Capital Budgeting
- Working with Scenario Categories
- Whitepapers
- FAQ
- Support
- Scripting
- Store
Using Expressions in Quantrix
Quantrix offers 'slicing and dicing' capability. You can easily create dynamic charts and presentation canvasses that can be changed 'on the fly' as you drag and drop the categories among the different axis. However, entering static text labels on the chart to identify chart elements isn't ideal as changing the category item orientation makes the labels inaccurate. First introduced in Quantrix 2.0, "Expressions" to make your charts even more dynamic. Expressions are a lot like formulas except they do not have a left hand range. Expressions are used to access data inside the model for presentation or display purposes. Expressions can be used in conditional formats, custom filters, chart series and annotations, as well as in page headers and footers. In this Modeler note, we will explore using Expressions in a presentation canvas chart.
| Utilizing the Cars Expanded sample model, we have created a canvas containing a line chart with the Scenario, Region and Sales categories in the canvas filter tray. With this particular representation, it would be useful to insert a text annotation so the user can see that he/she is looking at the Unit numbers for the Best Scenario in the All Regions in the chart. However, after you insert the annotation and change the scenario item in the filter tray from Best to Worst (and the region from All to CT) you will see that the text annotation does not reflect the change in the items (see screen shot on the right). |  |
With Quantrix, we can utilize Expressions to get the text annotations to change accordingly. In this example, the three annotations on the canvas are utilizing Expressions. Specifically:
|
 |
| Expressions can also be utilized in the chart axis labels. On the first screen shot at the top of this page, the X-axis labels default to the item names. (Year1:Q1) While the item names are useful, we can make these labels look more professional using Expressions. Expressions for chart labels can be entered by accessing the Format Toolbox > Chart section and editing the Point Labels. In this example we entered the following label Expression: @Quarter&" in "&@Year This Expression will provide spacing and the more readable word 'in' for the label so that 'Year1:Q1' turns into 'Q1 in Year1'. Utilizing Expressions in your Quantrix Models quickly makes your models even more dynamic and provides a more professional presentation. |  |
Downloads:
>> Quantrix Expression Model
