Version 25.2 Product Release

Important Notice: All 25.2 models opened in previous versions of Modeler show a warning that the model was saved in a newer version. The warning displays to alert users who may have used a 25.2 function in the model, because that will break formulas in the model in the prior versions of Modeler. If you don’t use formulas, or you haven’t used any 25.2 formulas in your model, you will still see the warning if you open the 25.2 model in an earlier version of Modeler.

Improvements in Modeler Version 25.2.0

Modeler Highlights

Modeler users can now check out a model in read-only mode that is open on Qloud. When you check out a model that is open on Qloud, if the Qloud model has been edited you see a yellow lock in the Check Out dialog and the hover text says “Locked”.  When you click Check Out, a dialog displays explaining that the model is checked out on the server and locked, that the model can be opened only as read-only, and you will not be able to save any changes. If you continue, when the model opens in Modeler, the title bar says “Read-Only.” Although you can edit in Modeler, you will not be able to save your changes. If the Qloud user makes an edit after you have checked out the model in read-only mode, you will not see their changes in Modeler. When you close the model there is no prompt to save changes.

For usability, when you publish to Qloud, and you select “Update the existing Qloud model”, the name of the model as it exists on Qloud displays as visual confirmation of the existing model that will be updated if you continue.

During the course of the Modeler Publish to Qloud Wizard, a page clarifies the Qloud server to which the model will be published: this can be helpful for users who publish to multiple Qloud sites.

For ease of use, a new Text function called Hyperlink lets you enter a hyperlink in a cell by specifying a URL and (optionally) text to display for the URL. Modeler creates the properly formatted hyperlink for the cell. The URL must begin with a valid protocol such as http or https (a URL beginning with www will not load).

The URL argument must be a fully specified URL such as https://www.quantrix.com. No checks are made on the validity of the URL except that it must be a text value. The second optional argument is the text to display. If you supply the display text, the text representation of the argument shows in the hyperlink. If the second argument is present but is not text, a #Value! error is returned.

hyperlink (url, [display_text])
The hyperlink function generates a functional hyperlink in a cell when a properly formatted URL (such as https://www.quantrix.com) and optional display text is provided.

Note: The URL must begin with a protocol such as http: or https:.
url – A properly formatted URL such as https://www.quantrix.com
[display_text] – The (optional) text to display for the hyperlink.

A new Lookup and Reference function, index (list, lookupValue), returns the index of a value in a list.

Example: For the list (“Red”, “Blue”, “Green”, “Yellow”), position = index(list, “Blue”) would return the position 2.

The index function is a basic list manipulation function, and it returns the first index at which a lookup value exists. This can be used in combination with sort to find the ranking of an arbitrary list of values.

Note: if you use this function in a model and then open the model in a prior version of Modeler, the formulas will be broken.

index (list, lookupValue)
Find the index (1-based) of the first occurrence of a given value or values in a list or range. If multiple lookup values are specified, the result will be a list of indices, one for each lookup value. If the lookup value(s) are not found, the result will be a #NOT_FOUND error. Each answer will be separate, and can be tested for with isError() or converted to something else using clearError().

A new Lookup and Reference function, countall, lets you easily return the number of times something appears in a list or range. Countall is easier to use than countif, and should be used when you don’t need to include a condition. For best results, countif should be used only when a condition is involved.

Use countall to find elements in a list or range that match the value passed into the second argument as a replacement to countif. The drawback of countif is that it will first try to parse the second argument as an expression to check which can lead to inconsistent behavior if the text in a cell can be parsed into an expression.

countall (list, lookupValue)

Count the number of occurrences in a list (or range) of a given value or values. If multiple values are specified, the result will be a list of counts, one for each lookup value.

A new Information function, clearblank, lets you specify a value or list of values in which to find and replace blank values in empty cells, and if you don’t optionally supply a replacement value, blanks are replaced with zero.

clearblank (list, replacement_value)

list – A value or a list of values that may contain blank values.
replacement_value – A value you can optionally specify to replace the blanks, that defaults to zero. Note that if the function’s replacement value is an error value (#ERROR), the error value is a valid replacement value and will appear for the replaced value: For example, clearblank(list(“”, 1, “”), err(“#ERROR”)) results in the list {{[#ERROR, 1, #ERROR]}})

clearblank is useful when empty cells are processed such that calculations affecting them results in blank values. See Tools > Calculation > Calculation Settings, “Treat empties as missing” checkbox. This can lead to unexpected results when trying to do math with blank values.

A new Text function, split (string, delimiter, index) lets you split a text string and return part(s) of it by specifying an optional index and delimiter characters.

For example, given the text “25/12/2023”, the split function can be used to return the month as text.
result = split(“25/12/2023”, “/”, 2) will return “12”.

split (string, delimiter, index)

string – The string to be split.
delimiter – The character used to split the text strings (for example ‘:’ or ‘%’).
index – An optional parameter that lets you specify which part of a split string to return. For example, enter 1 to return the first part of a split string (i.e. the portion before the first delimiter character). If you do not specify an index value, then all parts of the split text string are returned. It will return an error, if the values are not as expected (text for string/delimiter and number for index).

A new Lookup function, filterbytype (list, type) lets you filter the list you specify for all values of the specified type from the original list

filterbytype (list, type)
Return a new list containing all values of the specified type from the original.
list – A list to filter
type – The type (one of “date”, “error”, “text”, “number”, “empty”) to keep

In the example below the filter type is number, so only numbers show in the “Filtered” matrix.

A new Lookup function, filter (list, condition) lets you filter a list so that the resulting list has only the values that satisfy the condition.

The condition will be a simple expression similar to countif, e.g. < 4, > “Brad”.

Filter a list based on a simple condition. The result will contain (in order) any elements that match the given
condition.

list – The list to be filtered
condition – A single condition describing the value(s) to keep. Must be surrounded by quotes or refer to cells containing the condition text. If the condition is an error value, the result is that error. If the condition is empty or cannot be parsed, the result is either a #VALUE error (note that this is different from selects(), countif(), and sumif()) or a trivial “=” condition, depending on the type of parse error.

For example, A1 = valueat(filter(Matrix2::C, “> 4”), 3)
returns the third item that is bigger than 4.

A new Lookup function, sort (list, [options]) lets you sort a list of values with optional arguments on the sort.

sort (list, [options]) Sort a list of values according to optional arguments. Note: number and date formatting are ignored; sorting dates according to alphabetic or alphanumeric order may not function as expected and is not recommended.

list – A list of values to be sorted
[options] – An optional string or strings representing different types of sort criteria. All options are caseinsensitive (e.g. “asc”, “Asc”)
“ascending”, “asc” (default) – Sort the list from smallest to largest.
“descending”, “desc”, “d”, “down” – Sort the list from largest to smallest (“ascending” will be ignored).
“case sensitive”, “casesensitive”, “cs” (default) – Upper case letters will be sorted ahead of lower case letters for strings and errors.
“case insensitive”, “caseinsensitive”, “ci” – The original order will be maintained for strings or errors that differ only by case (“case sensitive” will be ignored).
“natural”, “n” (default) – Sort all empty values to the front, then numbers and dates in numeric order, then strings and errors in lexicographical order (alphabetic order with digits considered as single characters that go before letters). This matches (assuming case sensitive) the sorting of rows based on cell values.
alphabetic”, “alpha”, “a”, “lexicographic”, “lex”, “l” – Same as natural, except that numbers will be sorted in with strings (“natural” will be ignored). For example, sort(list(1, “1x”, “14b”, 14, 2), “alpha”) will return [1, 14, “14b”, “1x”, 2].
“alphanumeric”, “alphanum”, “an” – Takes into account numeric ordering inside strings (“natural” and “alphabetic” will be ignored). For example, sort(list(“14a”, “2b”, 1, 2, “14b”), “an”) will return [1, 2, “2b”, “14a”, “14b”].

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

https://quantrix.com/help/modeler/Current_Release_Notes_Modeler.htm

Improvements in Enterprise Qloud 25.2.0

Qloud Highlights

A new right-click option from a single selected cell containing an image allows you to download a cell image to your default download directory. The right-click option to download image appears on the menu only if the cell contains an image, and will not appear if multiple cells are selected.

You can read the complete Qloud release notes here:

https://quantrix.com/help/qloud/Current_Release_Notes_Qld.htm

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 support@quantrix.com. General questions and inquiries can be sent to customerservice@quantrix.com.

Users can also access the Quantrix Help page here.

Thank you for your support of Quantrix!