Creating a survey and analysing the responses in qlikview

[Anonymous]

I have this survey kind of sheet.

Here each button acts as a radio button, so that only option gets selected.

When the user makes selection and clicks submit, the values/number of Yes and No should be stored externally so that I can analyse how many Yes/No selections were made for a particular question.

Is there a way to store that data so that I can do analysis of no. of yes/no for each question?

The data should be stored such that everytime the user opens, finishes the survey and closes the application, the responses should be added.

Thanks,

Koushik

[MayilVahanan · Accepted solution]

Hi

Try something like this

Create a separate variables for each yes and no questions. And assign value zero for all varialbes initially.

And In submit button. Creat a action like

vTotalYesFirstAnswer = vYesFirstAnswer +1;

where vYesFirstAnswer  variable is used in "First question Yes Answer".

Action :

vYesFirstAnswer  = 1

so vTotalYesFirstAnswer value contains the final results for first Yes Question . Similarly create for all.