The different types of matches are given as follows. Users can type the character and filter the field based on the match. Wildcard option is used to filter the fields based on given wildcard match. This option selects all the members present in the field. There is an option in the window “Include all values when empty.” It can be selected to include all values present in the field when the selected member has no data.Ĭlear List option clears the customs value list.

You can add multiple members in the list and click on OK.

Click on ‘+’ symbol to add the name in the list.

Click on “Custom value list” radio button.

A custom value list can be created by following the given procedure. Select the new members to be added as filter.Ī custom value list allows the user to type the member name and filter the field accordingly.

Once it is cleared you can select the new members.

None option clears all the selection made in the filter window. If you want clear all the selection made in the filter window and start a new selection, you can use this ‘none’option. This procedure adds the filter in extract data filter window. Then select ‘All’ option and click on OK. To exclude all the members in the list, first, click on ‘Exclude’ button. The filter condition is also added in the extract filter window. In this example, all members are included by clicking on “All” option. This option includes or excludes all members present in the field. There are two more option in the “Select from List”. You can include or exclude the members present in the field using this option. Filter condition in Tableauīy default, filter window opens the “Select from List” option. All the use cases and its filter conditions are explained below. The filter window has multiple options to filter ‘Category’ based on various use case. Once you click on OK button, it opens a filter window. In this example, we have selected’Category’ as extract filter. You can choose any of the fields and add as extract filter.

Tableau prep custom sql