Hello, first of all thank you very much for allowing this question. And thanks in advance for your collaboration. I've been reading multiple help posts and I don't understand the error ๐
My problem is the following:
I need: SELECT ENUMLIST DEPENDENT ON AN ENUMLIST
I have the following tables:
This happens to me:
I select the Attribute, but it doesn't filter the values.
I wish it were so. For ex.
I click on Color, and it shows the corresponding OptionsIDs.
The expression I am using to filter the TERMs is the following:
I hope someone can see if this is possible.
Thank you very much again!
Solved! Go to Solution.
Use this ๐
FILTER(Terms, IN([AtributosID], [_ThisRow].[Atributos]))
Hola Juan,
The expression you should use is:
FILTER(Terms, [AtributosID] = [_ThisRow].[AtributosID])
Providing that OptionsID is the Key and Name is set as Lablel in the Terms table.
Buenas Joseph, mil gracias por tu respuesta!.
But I can't get it to work... ๐
I do not understand the problem...
Using Filter, I also tried it in multiple ways and I don't know what happens.
I have passed the reference to LIST. But now it only compares when a single Attribute is pressed.
If I press 2, the Options button does not appear
The expression used is:
FILTER(Terms,LIST([AtributosID])=[_THISROW].[Atributos])
Hola Juan,
Please post screen shots of your tables from the editor. Thanks.
Anything else you need, tell me.
Thank you very much!
Use this ๐
FILTER(Terms, IN([AtributosID], [_ThisRow].[Atributos]))
You are amazing! WORKS!
Thank you very much Joseph!!
I have tried several times with IN and I did not understand it well... Now I have advanced, I have understood this better.
Thank you very much for your help!!
Welcome my friend! The key is to read the guide carefully, sometimes more than once, then experiment ๐
Yes, yes, yes, read, I read! but the beginnings are difficult! LOL.
I follow your words.๐ช
THANK YOU!!
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |