IDSB Banner

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). Expression



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:
  • {@Scenario} Case Forecast Projection for {@Sales}
  • Region = {@Region}
  • Growth Rate = {Unit Sales Growth::Scenario-1|0.0%}
Double-clicking on the annotation in the canvas shows the Expression being used, as per the Region Expression in the screen shot. The Expressions are surrounded by curly braces. The '@' command tells Quantrix to get the current item name value of the category specified. As you can see in the Growth Rate Expression, you can call items from other matrices and apply appropriate custom formatting. When you now change the items on the filter tray, the annotations utilizing the Expression change right along with the model.
Expression 2



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. Expression 3



Downloads:

    >> Quantrix Expression Model





idbs_banner_960x41
About Quantrix - Contact - Site Map - Refer A Friend - Support
Solutions - Products - Services - Community - Partners - Webinars - Learning - Store
© Copyright 2014 Subx Inc.-All rights reserved -+1.207.775.0808 -