FILTER
Basic Overview
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(Node, Level , 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). All FilterOperations can be found on this documentation page. |
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 |