How to Drill Down the Chart with different values in same column

[#1]

Hello All,

I am trying to create a survey dashboard, where I have a column which stores all the answers & another column stores all the respondents id. My question is I have created a chart, with answers vs count of respondents., but my scenario is suppose one of my answer is Gender(having 2 options Male/Female) & another answer, how you commute to office (option may be Bus/car/bike etc).

I wanted to show the chart with all female employees commuting through Car.  How I can achive this.

Thanks in advance.

Bhargava.

[#2]

Do you mean by drill down group? It can be created and edited in "dimension" tap, you can create by yourself. For more filtering, it can be done by adding a few expressions. You can upload some data examples or qvw in order to let the community members try on it. Hope it helps!

[oknotsen]

For which product is this question? QlikView or Qlik Sense?

Once you shared that information, a Qlik Community Member will move this topic to the right section.

[johnw · Accepted solution]

It sounds like your data model looks something like this?

Raw:
LOAD * INLINE [
Respondent,Question,Answer
Ann,Gender,Female
Bob,Gender,Male
Carla,Gender,Female
Ann,How do you commute to the office?,Bike
Bob,How do you commute to the office?,Bus
Carla,How do you commute to the office?,Car
];

And you want to somehow select Female and Car, and see, in the example above, Carla?

You could use a generic load to convert your questions into real fields.

Generic:
GENERIC
LOAD *
RESIDENT Raw
;

[#5]

Thanks John, for your Help. with this solution one issue is Ihave 14 questions & I have to select 14 fields to select the combination.  is any other way we can get all questions in one field.

Thank you once again!!!