Using dimension from another view

trprado
Participant I

How can I use a dimension from another view? If any links can help me. As an example, I have a view of the order price, and I want to use it in another view that has the payments to create a new dimension.

0 4 18.9K
4 REPLIES 4

trprado
Participant I

Solved, I included the view and using extends option.

Hi Thiago,

If you don’t want to extend for each time you need to reference a field from another view, you can reference the field via {viewname.fieldname} given that the views are joined at the model level! See here for examples: https://docs.looker.com/data-modeling/learning-lookml/sql-and-referring-to-lookml

But {view1.fieldname} this kind of usage in a "view2" giving me "Inaccessible view-view1" lookml error when the same "view2" is used in a model when "view1" is not involved. Any solution you can suggest?

Update : Just now read the rules to do this and the rules say view2 must be in the explore with view1. Any way we can achieve the same functionality without using view2 in the explore?

Hi, 

I want to create a new dimension when the existing dimension is yes  in the same view 

is it possible ?

for example:

Dimension 1 : with case statements yes or no 

Dimension 2 : if Dimension 1 is yes AND x is not null 

Top Labels in this Space
Top Solution Authors