topic Re: Select value 'Like' in QlikView

Select value 'Like'

sharon_siao — Wed, 11 Sep 2019 12:19:19 GMT

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.

Re: Select value 'Like'

Frank_Hartmann — Wed, 11 Sep 2019 12:31:39 GMT

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

Re: Select value 'Like'

sharon_siao — Wed, 11 Sep 2019 12:40:11 GMT

Thank you, works like a charm!