Refers to a specific segment of the economy that includes companies or organizations engaged in similar business activities. Sectors are used to categorize and analyze
Quintessence Functions
ReportAsync() performs calculations in the background (asynchronously from Excel). This is useful for larger reports, allowing you to continue working in Excel while the report
ExecuteScheduleAsync() works the same way as the ExecuteSchedule() function, but runs in the background (asynchronously when called from third-party applications). This is useful for longer-running
The SubArray() function is used to create a new array from a selected portion of an existing array. Syntax: Remarks: Examples: The examples provided below
The GroupBy() function groups a range of data into sets and calculates values for each set using aggregation functions such as SUM, AVERAGE, and COUNT.
The Join() function combines rows from two ranges of data into a single range. It works similarly to the join functionality in SQL (Structured Query
The FilterData() function filters a specified range of data based on given criteria and returns the matching results. Syntax: Remarks: Examples: The examples provided below
The IsDefined() function determines whether an input parameter has a value assigned to it. Related functions: IsDate, IsElement, IsNull, IsNullOrEmpty Syntax: Examples: The examples provided below are based
The IsElement() function checks whether a specified value exists within an array. Related functions: IsDate, IsDefined, IsNull, IsNullOrEmpty Syntax: Examples: The examples provided below are based on fictitious
Quintessence Studio is a desktop application used to browse data, create reports and custom calculations, and manage security for users and groups. It provides a
This article explains how to call Quintessence functions from Python using the Quintessence.py package. We will demonstrate this using a Report call. In Excel, the
This article describes how to create a self‑signed certificate for use with the Quintessence Engine. The certificate generated through these steps includes all required DNS
Quintessence functions return results following Excel’s population behavior, which may operate in one of two modes: The difference between these modes determines whether Excel reserves
The Sparse() function, together with Excel’s implicit intersection operator (=@), allows the user to edit blank cells inside a returned result. When the function recalculates,
The ExportExcel() function takes a data block and exports it into an Excel workbook. The function can also append worksheets to existing Excel workbooks. This
The ExportCSV() function takes a data block and exports it into a CSV file. This function is only available in the Quintessence Language (for example,
Similar to CsvToArray, the ImportCsvText() function converts a block of CSV-formatted data into an array. However, this function also allows you to apply filter expressions
PivotView() is one of the view options for displaying data retrieved from the RelationshipData() and TimeSeries() functions. This view organises the requested data into rows
GlobalVariable() allows users to access variables configured by the administrator on a global level. These variables can be accessed from the Quintessence editor (from artifacts
View More