# FILTER

#### Syntax <a href="#syntax.20" id="syntax.20"></a>

**FILTER**(*range; filterCondition; orientation*)

* *range* - the range which is to be filtered - ***Value type**: range*
* *filterCondition* - the condition which is used to filter *range - **Value type**: a row or column range with boolean values*
* *orientation* - the orientation of the filter evaluation - ***Value type**: constant (optional, <mark style="color:red;">vertical</mark> as default).* Possible values are:
  * *<mark style="color:red;">horizontal</mark>* - the *filterCondition* is a row, removing columns from *range*
  * *<mark style="color:red;">vertical</mark>* - the *filterCondition* is a column, removing rows from *range*

#### Remarks <a href="#remarks.17" id="remarks.17"></a>

* *orientation* can only be used as parameter if *filterCondition* is used as parameter as well.

#### Examples <a href="#examples.2" id="examples.2"></a>

In the two selected widgets below, the FILTER function is applied using these three widgets:

![](https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-a95eebd40362eba1e0e2bed03b2ef11c29540a45%2Fgrafik.png?alt=media)

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-ec783ea754f02ba6460af2bd38e77af69186053c%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-d730c30ea3035678151cd8c78a4cf4b707f856c4%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

**Other examples**

The two selected widgets below extract rows from the widget "winelist", based on different conditions.

![](https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-e534a7c597161336d83e26291ec92bb58edab3d7%2Fgrafik.png?alt=media)

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-3a529b5854f6aa17564be15f8c20355a2c888b38%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-9209b7ef8292e6eda982af840fe41f236baee65d%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>