Pricefx Classic UI is no longer supported. It has been replaced by Pricefx Unity UI.

 

Setting 'Is One of' Filter

If you need to enter many values into a filter, you can make use of the following options in the column context menu:

  • Set 'is one of' Filter
  • Set 'is not one of' Filter

Select one of these options and proceed with the following steps:

  1. In the pop-up window, select the right separator that is used in your data source. 
  2. Optionally, enter a symbol which encloses the values. 
  3. Copy and paste the filter values into the text field on the right. The values will get converted into lines in the bottom part.
    (warning) You cannot copy more than 1000 items here. 
  4. Optionally, you can edit, delete or add values manually. 
  5. Click Apply.

The 'is not one of' operator automatically excludes null values.

To solve this, use: 'x is not one of <list>' OR 'x is null'.
OR ~ Match Any.

Found an issue in documentation? Write to us.