Skip to content
Infoveave Help

CONCATENATEX

The CONCATNATEX function in Infoveave is used to combine the values within a specified column, considering a specified condition that filters which values are included.

Applicable to

  • Calculated Columns
  • Expressions

Return Value

The return value of the CONCATNATE function is a single string that results from concatenating the values in a column.

Remark

  • CONCATNATEX function can be used across Dates, Text, and Numbers columns.
  • CONCATNATEX function neglects all nulls and blank values.

Syntax

CONCATNATEX(<expression>,<condition>)

CONCATNATEX in Board Expression

ParameterDescription
ExpressionA placeholder in a function that is replaced with the actual widget and measure names.
ConditionA placeholder in a function that is replaced with the condition filter.
Widget NameThe specific name or identifier of the widget being used for data visualization in the specific Infoboard.
MeasureRepresents the name of the measure that is being displayed or analyzed using the widget.
DimensionRepresents the dimension column that is being displayed or analyzed using the widget.
Dimension ValueRepresents the specific dimension items within the dimension column used for the visualization in the widget.

CONCATNATEX in Calculated Columns

ParameterDescription
ExpressionA placeholder in a function that is replaced with the actual column names.
ConditionA placeholder in a function that is replaced with the condition filter.
Column NameThe name of the column in the dataset or Datasource that contains the values you want to analyze.
Filter ConditionA filter condition returns the data points that meet the defined condition that you want to analyze.

Write the CONCATNATEX function. For instance

CONCATNATEX(<expression>,<condition>)
  1. Where expression equals 'Widget Name'[Measure] and condition equals [Dimension Name]="Dimension Value".Replace Widget Name with the actual name of your widget, Measure with the required measure name, Dimension with the required dimension name and Dimension Value with the dimension value of the selected dimension name.
  2. To learn how to configure an Expression in Infoveave, visit the section Configure Expression.
  3. Replace <expression> with required [Column Name] and <condition> equals [Column Name]="Filter Condition"
  4. Replace Column Name with the actual name of your column and Filter Condition with the required condition to be applied on the columns.
  5. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns under Sources.