Dynamic Values in Variable Input

[ml8]

how do the dynamic values of the variable input work?

I have a filter based on a dimension - 'Region'

I have set a variable as a dimension 'Country'. How can i code this into the Dynamic Values of the variable input so it lists the countries relevant to that region.

[mfarsln]

Hi,

You can use Concat(Country,'|'). '|' makes country values to be added dynamically.

[ml8]

Thank you! exactly what i wanted.

can i go to another level based on this dynamic variable eg City. so i would select- Europe (Filter), UK(Dynamic variable), London (Dynamic Variable - remove any not in UK)

[mfarsln]

Hi, 

You can create another variable object with Concat(City,'|'). When you select Europe and UK only UK cities will be the alternatives. 

[garvitgupta96]

=Concat (distinct aggr(only({<Country={$(your country variable)}>}city), city), '|', aggr(only({<Country={$(your country variable)}>}city), city))

Please mark the answer correct if this solves your problem

[Enriquemmesteo]

Hi, I have a similar situation at hand. I have a field "Names". I want to create a series of variables eg: vTeamLeader, vsupport...

I have a series of variable inputs for them to manually enter the names and I want them to be selected as a dropdown from the values in the field "Names".

Should I use the formula (Concat(Names,'|')) when creating the variable or in the dynamic values of the input?