Can I use Qlik to analyse survey data with multiple choice responses?

[#1]

Hi,

I'm very new to Qlik so apologies if this has been covered in another discussion, I've tried to find something that is similar to my query but it seems the replies are much more advanced than my beginners knowledge.

I would like to know what I need to do to my data download to enable me to display who the pet owners are.  At the moment when I load my data file into Qlik I can only show one or the other, what do I need to do to show multiple animals in one chart? what coding is needed?

I know that this is possible I'm just not sure how to do it - I've attached the data set so you can see what I'm working with.

Thanks in advance.

[neelamsaroha157]

may be you can use something like this

[rwunderlich]

If it's just two choice columns you are concerned with, it might be easiest to load the, both into a single "Pet" field:

Owners:

LOAD Serial,

      [Which of these pets do you have in your household...

<em>(select all that apply)</em>

Dog] as Pet

FROM

[Pet Owners survey TEST.xlsx]

(ooxml, embedded labels, table is [Raw data]);

Concatenate (Owners)

LOAD Serial,

    [Which of these pets do you have in your household...

<em>(select all that apply)</em>

Cat] as Pet

FROM

[Pet Owners survey TEST.xlsx]

(ooxml, embedded labels, table is [Raw data]);

Then you can have a listbox for "Pet".  In a chart you can use "concat(Pet, ', ')" to list the Pets this Serial owns,.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#4]

Hi Neelam,

Thanks for getting back to me, unfortunately I wasn't able to open your .qvw document, I've only go .qvd or .qvx.

[#5]

Thanks for your suggestion Rob, I thought that I needed to do some kind of coding involved.

As I mentioned to Neelam I'm unable to open .qvw files, I appreciate you including the coding which I will have a look at in my data.

[neelamsaroha157]

Hey Carlene,

Apologies I could not reply earlier because I was on vacation.

Attaching the file again. Let me know if you can open it.