Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
Occasionally, we would want to have a chart show everything except the values selected in a filter. For this use case, we recommend using the following SQL in your chart query. 
    when '[Filter_name|Default]'= 'Default'
      then 1 = 1
    else not [Column_name=Filter_name]
For the above example: 
  1. If no filter values are selected, then all results are shown
  2. If one or more filter values are selected, then we show everything but those values
Enjoy 🙂
Version history
Last update:
‎03-02-2023 08:58 AM
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: