I would like to use nested variables:
I have a dropdown button with two items: 'don’t filter’ and ‘filter according to parameters’.
When I choose the option ‘don’t filter’ I, well, don’t want to apply filtering on certain components.
When I choose the option 'filter according to parameters’ I want to apply a filter that also takes one or more other variables into account.
Currently I have a variable that I use for filtering, where the variant including filters looks something like this:
FILTER "MY_TABLE"."MY_COL" > <%= myvar %>;
However, this does not seem to work as the myvar variable is not replaced by the value of the variable.
Any ideas how I can have a filter that is disabled, or executed using other variable(s)?