Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Difference in Filter Appearance

  • 15 November 2019
  • 7 replies
  • 52 views
GenDemo
Userlevel 4

Hi All


silly question, but I am curious. Why does Looker show/allow different filters to appear differently…

In the screen shot below, you’ll see the Bills Status is a text box, where you can type in multiple values. While the status in the last filter is in separate boxes with dropdowns.


image

7 replies

zckymc
Userlevel 3

Have you used a liquid CASE statement to define the last filter?

GenDemo
Userlevel 4

what is liquid?

Quinn_Wildman
Userlevel 4

What is liquid?



This should get you started: Using HTML and Liquid with Looker

izzy
Userlevel 7
Badge +1

@GenDemo, I think Zack’s on the right track here though. When you use a lookml case statement, the filter options are restricted to only those choices and you see the filter appearance demonstrated by the last filter in your image.

zckymc
Userlevel 3

Sorry, yeah I meant LookML, not Liquid 😛

GenDemo
Userlevel 4

ah right ok.

So if you have it in a LookML case statement, then it gives you a drop-down.

izzy
Userlevel 7
Badge +1

Yup, that’s correct.

Reply


Terms of Service