A selection problem..

[#1]

So, I need a little help. I've got an app I'm working on that deals with questionaires. The questions are like the following How would you rate us, generally? With the answers being

1. Excellent
2. Good
3. Average
4. Poor

The problem arises from the user clicking on 'Poor' in a list box, and expecting to see all the questionaires in which there was a poor answer, as well as a list of the questions. The questions should be contexted with the average rating of that question, as well as the count of times that question was answered poorly.

The data is structured as follows:

Evaluations

id	completedBy	questionaireVersion	complete	completed
1	Bob Roberts	10	Y	1/21/2010
2	Nob Doberts	12	Y	1/22/2010
3	Doe Janeson	11	N	2/22/2010

Questionaire

version	description	created
10	client-2	10/24/2008
11	employee-1	8/9/2009
12	manager-6	7/8/2009

Questions

id	question	answer	questionaire
5	How's our product?	Excellent	10
6	Rate the customer attitude	Poor	11
7	Rate the employee's effectiveness	Average	12
8	How was our timing?	Excellent	10
9	How do they compare?	Excellent	12
10	Rate your Qlikview solution	Excellent	11
11	Rate the system's flexibility	Poor	11
12	Name	Doe Janeson	12
13	Date	1/21/2010	10
14	Supervisor	D. Jameson	11

So -given list boxes for answer, question, and completedBy- the user expects the following when clicking on 'Poor' in answer:

Synthetic Results

Question	Average	Answer Count
Rate the customer attitude	73%	210
Rate the system's flexibility	57%	24

Any suggestions on how one might solve this?

[vgutkovsky]

Alexander,

I think it would help if you posted a screenshot of your Table Viewer.

Regards,

[#3]

Sorry for the delay in response, had to generate synthetic data.. my actual model is much more complex.

[Oleg_Troyansky · Accepted solution]

Alexander,

1. For the average answer, use Set Analysis condition that ignores the selection of the Answer

2. For the proper count, add additional fields as counters when you load Questionnaiers, Questions, and Answers - something like the following:

load

...

1 as QuestionnaireCounter,

...

Then, simply summarize the relevant Counter to get the number of Questions or Questionnaires.

I hope I understood your needs correctly...