Sieve
The Sieve() function applies a mask to a range of cell values, hiding (filtering out) the entries that correspond to marked positions in the sieve range.
Syntax:
Qx.Sieve(Dataset, [Mask])- In Excel with Quintessence add-in versions prior to 25.1, use:
Sieve() - In the Quintessence Editor (Studio) using Quintessence language, use:
Sieve() - In the Quintessence Editor (Studio) using Python language, use:
Qx.Sieve()
ⓘ See parameter descriptions
| Dataset | The range of values to which the sieve is applied. |
| Mask (optional) | The sieve markers indicating which entries to mask. |
Remarks:
- The default parameters are:
- Mask: No mask is applied. The function returns the original Dataset unchanged.
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Use Sieve() to mask values
Data range (A1:C3):
| AAA | BBB | CCC |
| DDD | EEE | FFF |
| GGG | HHH | III |
Mask (E1:G3):
| X | ||
| X | ||
| X |
Marks in the mask indicate the positions to remove (markers can be any string. In this example we use ‘X’). Apply the mask:
=Qx.Sieve(A1:C3, E1:G3)Result:
| BBB | CCC | |
| DDD | EEE | |
| GGG | III |