Rate of events by area

[Anonymous]

I have a table of events by age group (5-year bands), sex, ethnic group (four groupings) and location (possibly 2000 locations).

I also have population size for each of the locations by age group, ethnicity, sex.

I have a map outline file; I can easily see the number of events by location, and I can (obviously) drill down in Qlik Sense to see the number of events by ethnic group, location, age, sex...

What I would like to do is to load the population data into Qlik Sense.  The idea is that I would like to look at the map after selecting, say, males in the 40-50 age group and have the map display the rate per 100,000 of population in that age group or whatever combination I select.

Does anybody know how I should load the population data so that the joins are appropriately made?  I bet you all do this stuff all the time!  Be patient - I'm learning, and only at the "drag and drop from Excel" stage.  Thank you.

[agni_gold]

As per your question ,

you have only one table in which locations by age group, ethnicity, sex dimensions are present.

So this should not created any problem on selection.

Does anybody know how I should load the population data so that the joins are appropriately made?

For this statement I am thinking you have more than one table.

Please clear your question and provide some details of your tables (Columns ) or sample data.

[Anonymous]

Thanks, Agnivesh,

Population by region, age group, sex and ethnicity is in a single table.  It's drawn from a pivot table, so I can re-shape it in any way I like.  The table, in effect, shows the number of, say, European males aged between 40 and 49 who live in a particular suburb.  The number is, of course, a single cell.

I want it to join to an "event" table.  This table, of accidents, has a single row for each event; the accident event has columns for the age group, ethnic group, sex, and residential location of the subject.  (Each event has a key field that successfully joins to several other tables.)

Does that help?  I'm away from work for several days so I can't immediately provide a table.  I hope this description does the trick!

Thank you,

Steve