I have a table that has a row [Type] with the value of Gas or Water. I’m trying to create a filtered view with a slice that contains the value. I have tried [Type]=Gas, [Type]=“Gas” neither filters out water. Please see below
Sorry if there is a thread about this. I could only find ones with numbers and dates.
Thanks for you help
It should be working, also with something like: IN("Gas", LIST([Type]))
Maybe the Table view is not yet pointing to the slice?
Your [Type] column in Logs table which you are trying to filter out is a REF column. So you need to construct your expression like:
[Type] = [Key_Column_Of_Referenced_Table]
Hello LeventK
I’m not following you on this.
So this is what I have
Table - [Logs] (ID, Date, Type, Level)
Table - [Type] (Type)
So are you saying the expression should be
[Type] = [Type].“Gas”
Which table the [Type] column in your Logs table reference to and what’s the key column of that referenced table? Can you give a screenshot both from the column structure and gSheet of that table?
There is only 1 column in the [Type] and it is called Type
I also took a screenshot of the output as well.
I thought I had the expression correct but I didn’t work.
Thanks for your help
Can you try with:
[Type] = [Type].[Type]
LeventK:
[Type] = [Type].[Type]
Same thing
The Type column is of type Ref:
When a Ref-type column value is displayed, the label column value for the row referenced by the Ref column value is displayed instead of the Ref value itself.
It seems odd to me your Type column would be of the Ref type. Is that intentional?
@Steve
@Virgil_Wilson said that he has a TYPE table, with a column named Type as well, it’s a single column (both key & label) with merely 2 records: Gas and Water respectively.
Looks like I’m confusing things–too many cooks in the kitchen! I’ll step out of your way.
@Steve mines are fried already bud Take care…
The column is a ref because I don’t want hard code the value in the Enum. So it is a ref so it can get the different type of “TYPES”
Actually you don’t need REF for that. You can construct a SELECT expression in the Valid_if and can keep the column type as ENUM or even TEXT:
SELECT(Type[Type],TRUE,TRUE)
OR merely
Type[Type]
I suggest change the column type from REF to ENUM (base text) and use one of the expressions in Valid_if. Also explicitly mark Allow other values to TRUE. Keep your slice expression as:
"Gas" = [Type]
Sorry for the question I’m a newbie of 3 days.
I suggest change the column type from REF to ENUM (base text) and use one of the expressions in Valid_if . Also explicitly mark Allow other values to TRUE. Keep your slice expression as:
I did change the column type to ENUM on the table. Where is the Valid_IF and Allow other values TRUE at.
