topic Re: Creating a bar chart from survey results in QlikView

Creating a bar chart from survey results

Wed, 25 Nov 2020 16:16:04 GMT

I have the following survey results

Response ID	Response
1	Within the last year
2	Within 2 years
3	Within last year
4	Within last year
5	5 years or more
6	Within the last year

How do i create a bar chart with count of responses, per response. Response on the x axis.

Thanks in advance,

Rebecca

Re: Creating a bar chart from survey results

buzzy996 — Tue, 07 Feb 2017 10:45:28 GMT

seems to be all are different conditions, so u can use ur Response ID as ur dimension and on ur expression if Response ID=1,then count(Within the last year responses)

2nd expression: if Response ID=2,then count(

Within 2 years

r responses)..

so,similarly u can create 6 expressions.

HTH

Re: Creating a bar chart from survey results

vinieme12 — Tue, 07 Feb 2017 11:05:20 GMT

Use

Dimension

: Response

And

Expression

Count(Response)