Using filters to create a subset based on another field

[federicolinares]

Hello,

I'm new to QlikSense so apologies if the question is too straight-forward to answer.

I have the following data scheme:

Encuesta is a "poll" with pregunta (question) and respuesta (answer). This structure is like that because for some questions multiple answers can be selected. The result is multiple rows identifying the same polled person with all answers given to each question. Some questions are used as "filters" (filtro) since they allow to segment the public by sex, city, etc. The Fecha table registers the date when each polled person was asked.

Let's say I want to filter by sex. So, I want to know what people who have answerd "male" to the "filter question" 'what is your sex?' have answered to all other questions (included "filter questions").

The way I look at it is that I need the list of all "IdEncuesta" (PollID) linked to those rows with values "what is your sex?" and "male" in columns "Pregunta Filtro" (filterQuestion) and "Respuesta Filtro" (filterAnswer).

That set of "IdEncuesta" records in all tables will be the basis for additional filtering conditions.

How can I implement this solution with Qlik Sense? 

Many thanks in advance!