2 Replies Latest reply: May 22, 2015 8:29 AM by Sara Tallhoff RSS

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

      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

        • Re: Filter pane - connecting two dimensions (questions in a survey)
          Friedrich Hofmann

          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

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

              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

              table.png

               

              //Sara