topic Re: Macro or something similar in QlikView

Macro or something similar

Wed, 03 Apr 2013 19:45:28 GMT

I have a list of countries and I want to create a list (or something else) so that when I click the name it selects a set of countries.

Example: a list of regions (north america, south america...) when I click north america I want it to go to my table and select canada, us and mexico.

How do I create this list?

or those buttons?

or whatever I need to create to make it happen.

Re: Macro or something similar

Siva_Sankar — Thu, 04 Apr 2013 05:28:13 GMT

I didnt get any clear idea. See the attached qvw file.. and let me know more details to help you better. Regards. Siva

Re: Macro or something similar

sushil353 — Thu, 04 Apr 2013 05:45:33 GMT

Hi,

Please find the attached app...

HTH

Sushil

Re: Macro or something similar

prasad_dumbre — Thu, 04 Apr 2013 06:52:04 GMT

Hi,

From What I understood from your post is, You are having a list of countries, now you want to group them based on something such as Continet. So, if you select Asia then countries in asia should get selected like that

If it is so, and you dont have grouping field (Continet in my eg.) then you simply create a excel or inline table having two fields First, Countries and second Continent. Now using applymap you add that second column required for grouping in your table.

Hope it helps. Reply in case of query . . .