Filter pane - connecting two dimensions (questions in a survey)

[s_tallhoff]

Hi,

We are working a Qlik Sense app containing of data from a survey.

We now want to do a filter pane to filter out different answers of a question.

There are two questions not connected to each other but by respondent ID (which will never be shown in the visualization)

We want to filter on the answers of question 1 and depending on the respondent ID of those answers we want to show the question and answers of question 2 for those specific respondent IDs.

Example:

Question 1 - Who trained you?

Answers:

Anna

Adam

David

Mark

Olivia

Question 2 - I have recieved adequate training

Answers:

Strongly agree

Agree

Disagree

Strongly disagree

Not applicable

What we want is a filter pane containing the trainers (Anna, Adam....)

Then a chart showing question 2 depending on the filter (connection is respondent id but this will not be part of the visualization).

Thanks in advance!

//Sara

[datanibbler]

Hi Sara,

if I understand correctly, then all you want is actually to link the two tables by the respondent's ID, but not show it on the GUI. Right?

Well, you can keep that off the GUI and use for ex. the AutoNumber() function on that field in the script to construct an alternative key that you can use to link those tables. Then you can throw out that field altogether.

It depends of course on how the users will access your app. Do they go via their Browser or do they have the Client installed?

Best regards,

DataNibbler

[s_tallhoff]

Hi,

Thanks for your quick response. All the fields are in the same table (see attachment) but still we can't filter on one question connected to another. Maybe it's very easy but we are not experienced at all and can not make it work

Script:

LOAD

  Answer,

    [Email Address],

  num(autonumber(Subfield(Question,' - ',1))&'.'&AutoNumber(Subfield(Question,' - ',2))) AS FullQuestionID,

  AutoNumber(Question) as QuestionID,

  Question,

  Subfield(Question,' - ',1) AS MajorQuestion,

  Subfield(Question,' - ',2) AS MinorQuestion,

  RespondentID

//Sara