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.
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!