2 Replies Latest reply: Jun 3, 2016 5:00 PM by Steve Holmes RSS

    Rate of events by area

    Steve Holmes

      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.

        • Re: Rate of events by area
          Agnivesh Kumar

          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.

          • Re: Rate of events by area
            Steve Holmes

            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