Auto Populate allowed_value: in Parameter/Filter-Only Field

Looker Q&A Looker
1

Is it possible to query a table, and load all the results from one of the columns into the allowed values of a Parameter/Filter-Only Field?

1 Like
2

I don’t think it’s possible to fill in the allowed_values of a parameter, but you can use the values as a filter-- See my response here linking out to two other posts

[Can we use the results of one Look as filters of other Look dynamically?](https://discourse.looker.com/t/can-we-use-the-results-of-one-look-as-filters-of-other-look-dynamically/11318/2) LookML
3

Can’t you use the suggest_dimension parameter?

4

You can use suggest_dimension, but it isn’t the most flexible choice. You can’t really take the results of a true query and load them into a dimension to use as a suggest_dimension.

If you have something simpler, then that would work fine, but if you start needing lots of filters and special conditions you wouldn’t be able to leverage it. Excellent idea though, I hadn’t even considered it!