topic Re: Create chart showing survey response distribution in QlikView

Create chart showing survey response distribution

Sun, 29 Jul 2012 20:28:05 GMT

Hi -

I'd like to create a chart showing the distribution of survey responses. The survey scale is 1 to 10.

The value for each [EMPLOYEE_ID] is contained in [Q1].

Dimension = [Q1]

Expression = COUNT ( DISTINCT EMPLOYEE_ID )

This works as expected, it plots the number of employees answering 6, 7, ... etc.

The problem is that i'd like the graph to show all 10 columns and the data does not contain some of the possible values.

For example, there are no 1's so the chart starts at 2.

Any ideas please? Thanks!

Pat

Re: Create chart showing survey response distribution

swuehl — Sun, 29 Jul 2012 20:41:33 GMT

Create an additional table containing your field Q1 with all values:

Table:

LOAD recno() as Q1 autogenerate 10;

And disable 'Suppress zero values' option in presentation tab.

Hope this helps,

Stefan

Re: Create chart showing survey response distribution

Sun, 29 Jul 2012 20:47:46 GMT

Brilliant. I just added 10 rows to my data set with EMPLOYEE_ID with blanks and 1 - 10 in the Q1 values.

Thanks!

Re: Create chart showing survey response distribution

Lee_Matthews — Mon, 30 Jul 2012 01:20:20 GMT

Hi Patrick

There used to be a training evaluation application on the demo site that presented feedback in much the way you are after. I have attached the application. This might help with your formatting and other UI work.

Regards

Lee