Version 21.2.0 Product Release - Updated

PRESS RELEASE: Version 21.2.0 Product Release Notification

Update: March 14, 2022 for 21.2.2 release

Quantrix scripting already has great contextual access to properties and methods (just hit CTRL+Space while in the script editor), but for those who want a more comprehensive view, and to see what’s possible outside of Modeler, we now offer a complete online reference (QM-24430). The new documentation is easy to use and navigate, with user concepts linked to their respective methods and properties. For example, if you click “Category”, you will see all available methods for every class, and if you click one of the classes, such as for Category background, or font style, more information displays. If you click on an entry that is covered in the Groovy documentation, or is a Java type, we conveniently link you to those respective external sources of documentation. Please visit the new scripting documentation.

December 22, 2021

PORTLAND, ME – On December 22, 2021 Quantrix released Version 21.2.0 of Modeler, Qloud and Enterprise Qloud. There are a variety of new improvements and fixes with this release, so it is recommended that users update their software as soon as possible. 

Modeler Highlights:

Training Resources on the Launch Panel:
Quantrix Modeler includes invaluable new resources on the Launch Panel: the Quantrix Tutorial Model and six new Training models.

Data Import > Google Sheets:
Data Import includes a new Import Data option for Google Sheets:

Import Google Sheets lets you import Google Sheets from your Google Drive, and bring in all or selected data to a Data Import matrix. Access Google Sheets using the Data menu > Import Data > Google Sheets. Import Google Sheets leads you through choosing the Sheets and data to bring into Quantrix. Please note that you can’t currently run update on a Google sheets data type on Qloud.

Data Imports from a database source show a new Cancel button during the database connection phase (“Establishing a Connection”) so you can cancel the connection quickly.

Data Imports from a database source have a new optional Max rows option: When you click to select a table, the Max rows option appears. If you select the option, you can enter a number in Max rows to limit the data source to that number of rows.

This can help you prototype a data import more quickly when the source is slow or large. Note that the Max Rows limit remains in effect when you click to exit the data import configuration. When your prototyping is complete, enter data import configuration again to remove or adjust Max Rows if desired. Note that if the database type is not supported, Quantrix will not be able to issue the necessary SQL to perform the Max rows query, so the Max rows field will be disabled.

Data Import’s Configure Data Source is improved to let you choose whether to put the imported data from a new data import into a new matrix (the default), or into an existing non-data import matrix for any valid data source types. This feature will be useful if you prefer to prototype the structure of your models prior to injecting data, or if you would like to populate our sample or other templates with new data. This major enhancement incorporates multiple features including the new Configure Import into Matrix dialog for importing into existing matrices.

If you choose the option to import into an existing matrix, you will have two choices for how to do this: using drag and drop, or using the Configure Import into Matrix dialog. Using drag and drop, you can drag fields from your source as categories, data categories and groups as usual, and you can now drag them on top of existing categories to replace the items and data in those categories using the data from the source fields.

The new Configure Import into Matrix dialog offers a list based method for performing the same actions above. It incorporates heuristics such as matching and preselecting existing category and field names when possible, and it also converts existing categories to data categories (where appropriate), and allows you to further set formatting or binning of fields using a gear icon.

Data Import’s Database Configuration panel is improved and includes a new filter box: when you enter a term in the filter box, only schemas, tables and/or fields that match the filter term are shown in the data tree. If you enter “product” in the filter box, and there are multiple tables and fields containing the term product, the data tree shows all tables and fields containing the term product. The filter box is available for both Select Tables and SQL Query.

To find out more, you can read the full Modeler release notes here:

Qloud Highlights:

Qloud 21.2.0 introduces a significant re-implementation of most front end objects including matrices, views, charts, and canvas components in a more responsive web technology. This change improves interactivity and performance while simultaneously improving system efficiency. On average, Qloud 21.2.0 makes 50% fewer calls to the server, and for each, may reduce the data exchanged by up to 80%. Large models load more quickly and many common interactions are performed client-side, resulting in a more seamless experience for users while they navigate, make selections and edit data. The enhanced efficiency should also improve performance for users on less ideal networks. We have invested a lot in this transformation and will continue to make improvements over subsequent future releases.

Qloud now supports the $RoleName environment variable feature, as configured in Modeler. Previously existing User Role behavior makes it easy to limit access to different parts of a model to users with different roles. This new variable now makes it easy to allow different roles to access the *same* part of a model but populate it with a different view of the data. For example, it is now possible to set a filter on the P&L matrix such that the “North America” role only sees data from the US, Canada and Mexico, and the “Europe” role only sees data from France, Spain, Italy etc.

Qloud users can print one or more views to a single PDF file using a scripted button on a canvas provided it was set up in Modeler. When you click the button to export to PDF, the function generates a file name for the export based on the model name and exports the pdf to the location the browser uses for downloads. This feature will allow model-based application designers to easily empower their users to create configured printable reports.

A new Qloud feature, Current Users, supersedes the former Chat feature. Current Users lets you easily see who is in a model when there are other users in the same model.

You can read the Qloud release notes here:

About Quantrix

Quantrix helps businesses modernize their finance and operational practices, increase efficiency and transform their operations by providing a platform that improves throughput, analytics, traceability and sharing of critical business data and insight.

For any technical questions, please feel free to contact General questions and inquiries can be sent to

Users can also access the Quantrix Help page here:

Thank you for your support of Quantrix!


Watch our new video to see what’s new