5 Replies Latest reply: Mar 8, 2013 4:35 AM by katieoliver RSS

    Summarise data whilst still being able to make selections

      Hi there,

       

      I have the results of a survey in a database table.  The table is in the following format and has been loaded alongside hundreds of other survey answers. 

       

      We have asked people about how they would like to receive different types of messages.  If they like to receive Type 1 messages by text and email, they tick those checkboxes in the survey and the results appear as a 1 in the database.  If they don't tick the box, the value in the database is 0.  In a previous question they are asked which country they are from.

       

       

      Country Type 1 - Email
      Type 1 - TextType 1 - InternetType 2 - EmailType 2 - TextType 2 - Internet
      UK111011
      USA110110
      India100110
      UK000001
      UK000111
      India011101
      USA111110
      USA111010
      USA111011
      UK111110
      UK110101

       

      I would like to display the above data in QlikView in the following way and still have the option to create a listbox for Country so that I can make selections to view the results for the selected country.

       

      chart.jpg

      Does anyone have any idea how to achieve this?!

       

      Many thanks for your help,

       

      Katie