3 Replies Latest reply: Nov 9, 2015 5:39 PM by Andy Weir RSS

    Show Avg and Count in Bar Graph

      I have a Qlik Sense bar graph sowing survey response averages. This is the expression I am using: avg({<[Question Type]={'Numerical'}>}Answer)

       

      How can I also show the count for my values? As in, "the average for survey question #1 was 4.2 on a scale of 0-5.  And the number of responses was 340."  I read a discussion where it seems two measures cannot be included in one graph. I don't mind having a combo graph.  I am new to Qlik Sense and as such will need to experiment with combo graphs, too.  TY.

        • Re: Show Avg and Count in Bar Graph
          Andy Weir

          You should use a combo chart for this.  primary axis being the average responses and the secondary axis set to measure the number responses.

           

          YOur dimension being the questions

           

          HOpe this helps

           

          REgards

           

           

          ANdy

            • Re: Show Avg and Count in Bar Graph

              Thank You, Andy.  I'll follow your advice.  I also just realized that my count of number of responses needs to be thought through because as it turns out, the data set I am looking at shows each question asked as a unique row. If john took a survey with 15 questions asked, he appears in 15 rows. If he took another with 10 questions, he appears in 10 rows. I don't see any unique identifiers like data/time stamps. I'll keep on pluggin' away...