Converting Yes No answers

[#1]

Hello

I have a set of survey responses with the majority being yes/no answers or similar drop down options.

I need to create some pie and bar charts out of this information, but I can't seem to make it work in QlikView.

I have tried counts, but I'm making no progress.

I am aware this is a simple issue, but I've always used numeric data in the past and it hasn't been a problem.

Appreciate any help.

Thanks

CS

[swuehl]

Could you post a small sample app, some lines of your input data and / or the chart dimensions / expressions you are using?

It's hard to help you without these informations, though you should find a lot of similar topics here in the forum (try the search at the top right).

Regards,

Stefan

[francescopuppin]

You simply need to make a chart (I suggest you to make it as straight table initially) with

Dimension: ANSWER    

Expression: Count(SURVEY_ID)

Where ANSWER is your field containing the answers (yes, no, etc..) and SURVEY_ID is your field containing the unique identifier of your surveys (e.g. if 100 people submitted the survey, you should have 100 different IDs)

I hope it helps

Regards,

F.

[#4]

Hi,

PFA.............!