16 Replies Latest reply: Apr 19, 2017 7:21 AM by Goutham V RSS

    Bar Graphs to take input from multiple fields(columns in db) combining those to produce single value

    Goutham V

      Hello All,

       

      As i am new to QlikSense, i have a task to produce the graph and which takes data from the db.

       

      DB Tables:

       

      Survey

       

      survey_id    lender_offer_id              answer_text 

      10                       1                           Strongly Agree

      11                       1                           Agree

      12                       2                           Excellent

      13                       2                           Above Average

      14                       3                           Strongly Agree

      15                       3                           Agree

       

      Here is my Script:

       

      LOAD `survey_id`, 

          `lender_offer_id`,

          `survey_question_id`,

          `answer_text`;

          SQL SELECT `survey_id`,

          `user_id`,

          `lender_offer_id`,

          `batch_meta_data_id`,

          `survey_question_id`,

          `answer_text`

      FROM SURVEY;

       

      My Goal is to produce a bargraph that must produce a percentage to know how much percent of people opted to particular Option in the Survey.

      But restriction here is i must take Strongly Agree and Excellent as Strongly Agree, Agree and Above Average as Agree by totalling.

      For eg:

      In the above table total 3 persons opted for Strongly Agree(Included Excellent) and 3 for Agree(included Above Average).



      How can i do that using  QlikSense.