User Guide Getting Started Help Center Documentation Community Training
New LookML
Old LookML
New LookML
  
English
日本語
can_filter

Usage

view: view_name {
  dimension: field_name {
    can_filter: yes
  }
}

Hierarchy

can_filter

Possible Field Types

Dimension, Dimension Group, Measure

Accepts

A Boolean (yes or no)

Definition

The can_filter parameter enables you to prohibit a dimension or measure from being used as a filter. For example:

dimension: description { can_filter: no }

The default value of can_filter is true, meaning that dimensions and measures can be used as filters as you would expect. However, there may be some cases when a field may be too demanding to search (like a large text description), and in these situations you can prevent that field from being used as a filter. Users will simply not see a FILTER option when they hover over the field.

Please note that can_filter cannot be used with:

Additionally, drilling (see drill_fields) will not be permitted if a can_filter dimension would be required in the drill. This occurs when:

Top