Derived table - To use filters created in the Case When Clause of the Derived table create Syntax

[ammu]

Hi,

I have created a derived sql view with some filters in it say:

“filter: abdc {
    type:  date)”

Now I want to use the same filter “abdc” in the select query (derived table formation query)of the same derived sql. Could someone help me on this.

Thanks in advance

[fabio1]

Hi @ammu ,

You would include  ` {% condition abcd %} my_table.my_column {% endcondition %} ` into your SQL

Our docs page on templated filters has a more in-depth example:

https://docs.looker.com/data-modeling/learning-lookml/templated-filters