Is it possible to combine liquid params with a regular sql query in LookML?

[nikita42]

I have a dimension  (StageName) with 10 or so possible values. There are a few different combinations in which a user might want to filter these that are not mutually exclusive, so I’m trying to use a parameter that lists out different filter combos for the user to select.

I’m trying to create a yesno field something like this:

{%if param._param_value == ‘Option1’ and ${StageName} not in (‘Won’,’Lost’)%}  true

{%if param._param_value == ‘Option2’ and ${StageName} not in (‘Pre-Qualified’)%} true

etc..

{%endif%}

The idea is the user can select a single option and I can use the yesno field to filter out multiple values in the StageName making it easier for users.

This syntax doesn’t accept the StageName dimension and if I try it as a regular sql statement it doesn’t accept the liquid param.

Is this even doable? Any advice?