Hi there! Any ides in how can I filter the v...

(Aparicio Piñeyrúa) #1

Hi there!

Any ides in how can I filter the values in a Ref column depending if a condition is true or false in the table that is been Ref?

Eg: I had a table that has Cars information, model, company, year etc…

In other table the table that has the Ref column shows the cars names. I need to filter this Ref column if the car model is between year 1970 and 1980. Is there a way to do this?

Thanks! Apa

1 Like
(Aparicio Piñeyrúa) #2

@RezaRaoofi

Great! I will try and let you know

(Reza Raoofi) #3

An expression like this in the Ref column’s Valid_if should do the job:

FILTER(Cars, AND([Model]>=1970,[Model]<=1980))

(Reza Raoofi) #4

I deleted my first comment and posted another one right after yours! :slight_smile:

(Aparicio Piñeyrúa) #5

@RezaRaoofi

Many thanks Reza!

(Reza Raoofi) #6

You are welcome Apa.

(Aparicio Piñeyrúa) #7

@RezaRaoofi

Another question! :slight_smile: I had another table that I enter specific diferent type of leather seat canvas (as unique ID) where each one of this are Ref to a specific car.

Getting back to the previews table (the one that has the Ref valid if formula) how can I filter other column to select the seats that belong to the car?

(Aparicio Piñeyrúa) #8

@RezaRaoofi

I think I solve it:

=IN( [_THIS], SELECT(Canvas seats[UID], [_THISROW].[Car] = [Car]))

But how can I also filter depending on the type of canvas? Show be somthing like this:

AND(=IN( [_THIS], SELECT(Ficha Familiar[UID], [_THISROW].[SIPI] = [Alumno]), IF([Canvas])=“xx”,true,true))