FILTER

FILTER ADDED IN 1.19

Description

Filter the Node with the given filter values. The result will only contain the rows of the input cube that fulfill the filter.

Signature

FILTER(NodeLevel , FilterValue <, FilterOperation>)

Parameters

  • Node: Input node, specified using the node name in single quotes (e.g. 'Profit')
  • Level: The level by which the input node shall be filtered
  • FilterValue: The value by which the input node shall be filtered. This can either be a single string value or a list of strings
  • FilterOperation: How are the values checked against the filter. The default is "EQ"(equality). Other possible values are: "NEQ"(Not equals), "GT"(greater than), "GTE"(greater than or equals), "LT"(less than) and "LTE"(less than or equals).

Example

Input Node

Year

Product

Value

2015 M1 100
2015 M2 200
2016 M1 150
2016 M2 300
2017 M1 10


Output FILTER('Node', "Year", "2015")

Year

Product

Value

2015

M1

100

2015 M2 200


Output FILTER('Node',"Year",["2015","2016"], "NEQ")

Year Product Value
2017 M1 10



Was this helpful?

Yes | Somewhat | No