Select value 'Like'

[sharon_siao]

This is probably very simple. Suppose my data/table has two columns as follows:

Name                              Region

Name1                           South America, North America

Name2                           South America

Name3                          North America, Europe

Name4                          South America, Europe

Name5                          Europe, Asia

I want a drop down list on Region or some form of Region, so that if user selects South America then all Names 1,2,4 display and if user selects Europe, then Names 3,4,5 display. How do I set this up? Thanks for any help.

[Frank_Hartmann · Accepted solution]

see attached qvw.

Load *, subfield( Region,'-') as Region_New;
load * Inline [
Name,Region
Name1,South America-North America
Name2,South America
Name3,North America-Europe
Name4,South America-Europe
Name5,Europe-Asia
];

hope this helps

[sharon_siao]

Thank you, works like a charm!