Alteryx App: Checkbox replacing values in NOT IN statement. Error when no values selected

[alv728]

I'm building an app where the user can select from a list of film titles to exclude certain films, but there are scenarios where none are selected. This results in an error as the NOT IN statement does not receive any values. Anyone know of a workaround to allow non-selection of a list that won't error?

Error:  Filter (63) Parse Error at char(10): Not enough parameters for the function "NOT IN".

Screenshot of tool configuration attached

[DavidP · Accepted solution]

How about something like this? Sample app attached.

[ZacharyM]

Choose to update the value with a formula when you connect the Action tool to the Filter Tool - then write a formula to wrap the value from your parameter in a IFNULL() that will account for if they select nothing and pass the whole thing in as a replacement to your filter clause.

[alv728]

Worked like a charm, thank you!!