Why is there a dimension I didn't select in the GROUP BY of my explore?
Knowledge DropLast tested: Apr 17, 2020One way this can happen is if you include the dimension in the liquid/f...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
PDTs showing up 'Not built' in admin panel when they are built
Knowledge DropLast tested: Oct 22, 2018 This can be caused by commented out liquid in a PDT - commenting in Lo...
Using multiple values in a single parameter
In the event that you want to do something crazy like this:When you want parameters to be all they can be Para...
Can I use/reference a `filter:` of type: number in a liquid statement?
Knowledge DropLast tested: Jan 21, 2019 Yes, you can do this using the assign Liquid syntax. For example:filte...
Duplicate Views in Field Picker Using View_Label
Knowledge DropLast tested: Oct 21, 2020 Looker has an article about cool ways to use Liquid when labeling, but...
Dynamic Joins - How to use liquid to dynamically adjust sql_on conditions
Knowledge DropLast tested: Oct 22, 2019 Define the different join conditions within liquid if/then control flo...
Liquid doesn't work in HTML/link parameter when value is null
Knowledge DropLast Tested: Jul 31, 2019This issue is specific to how Liquid handles null (nil) values and how ...
Parameter Fields (Resources)
Knowledge DropLast Tested: Jan 21, 2019Parameter fields allow you to inject values from a UI filter.There is a...
How do I escape commas when using liquid {{value}}?
Knowledge DropLast tested: May 2020You can use {{ filterable_value }} as shown in the liquid docs.This content...
What are the allowed Liquid functions?
Knowledge DropLast tested: May 2020You can find the list of Looker-supported liquid variables in docs. You can...
Liquid Operators and parentheses
Knowledge DropLast Tested: Nov 16, 2017 Liquid formatting supports these operators listed here: https://help.s...
Can I use/reference a `parameter:` of type: number in a liquid statement?
Knowledge DropLast Tested: Nov 6, 2020Yes, you can do this using the assign Liquid syntax.For example:paramete...
Number Comparisons in Liquid
Knowledge DropLast tested: May 2020in Liquid the comparison operators are:< lesser than (= greater or equal to...
Using liquid 'split' to iterate (loop) over a string
Knowledge DropLast tested: May 2020This comes in handy when you has a comma-separated list and you want to for...
How can I make one column have a conditional format style based on another column's value?
Knowledge DropLast Tested: Jan 21, 2019 This is possible using Liquid in the html: of a given LookML field. Th...
Can you do nested if in liquid?
Knowledge DropLast tested: Jan 21, 2019Yes! Source though it may be less confusing if move one of the conditio...
Why isn't my dynamic liquid label changing when I change the filter value?
Knowledge DropLast tested: Aug 30, 2018 Is it changing in the visualization? Keep in mind that when a value of...
"Variable not found" error in liquid html
Knowledge DropLast tested: Jul 3, 2018 One reason you might get this error in liquid is if you use {{ }} and {...
Custom liquid formatting isn't displaying in visualization
Knowledge DropLast Tested: Jan 21, 2019DCL tip: To display custom liquid formatting, use {{ rendered_value }} ...
Is it possible to make the domain in the url of a `link` parameter dynamic, based on the user's instance environment (i.e. prod, dev, etc. )?
Knowledge DropLast tested: Oct 25, 2019 Simple CaseIn the url of a link parameter, you can omit the instance n...
