Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
Sometimes when using direct replacement filters, you may want to filter or manipulate your data differently depending on the value or values supplied by the filter. 
Consider the following example:
    when '[my_filter|Default]' = 'Default'
      then true
    else [my_column=my_filter]
In this example, in the case when the user hasn't selected any filter values at all, the code '[my_filter|Default]' will evaluate to the string 'Default', and the boolean expression in the case/when will return true and then the where clause will also return true.
Else, the where clause will evaluate to true or false depending on whether the records in my_column match the values supplied in my_filter.
The concepts shown here can be used for much more powerful exercises, such as creating a custom date aggregation filter, as explained here.
Version history
Last update:
‎02-21-2024 01:39 PM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: