Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sharon_siao
New Contributor III

Select value 'Like'

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.

1 Solution

Accepted Solutions
Frank_Hartmann
Honored Contributor II

Re: Select value 'Like'

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

2 Replies
Frank_Hartmann
Honored Contributor II

Re: Select value 'Like'

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
New Contributor III

Re: Select value 'Like'

Thank you, works like a charm!