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

# 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

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

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...

• ###### Re: Show Avg and Count in Bar Graph

Sounds like you have the right level ofgranularity so your number of responses to a given question can be found by grouping the count ofusers on a given question.  Something like AGGR(count(distinct responder) Question)