I have a scenario I need to add to a dashboard, and I wonder whether anyone else has run across this type of thing. Say you have a group of people who have all taken a number of different tests. I want to let the user choose a number of score ranges for various tests, and then have the dashboard return the set of people whose scores fell into those ranges, so they can see what their score was on another test. The score ranges and number of tests need to be under the user’s control, so they can write their own formula.
For example:
Give me a list of people whose score on test 1 is between 90 and 100, whose score on test 2 is 50, and whose score on test 3 is between 80 and 85, and tell me what their scores were on test 4.
All the test names are in one field, Test, and all the scores for all the tests are in another field, Score. Each Test and Score is linked by the person taking the test and the date they took it. I can’t just select values in Test and values in Score, since I will have multiple possible values in Score that will only be relevant when they correspond to a particular Test. There are hundreds of existing Tests and new ones being created all the time, so the set of tests any person has taken will vary.
What I’m looking for is not an aggregation—I’m looking to find the set of ID numbers of the test takers who meet all the criteria, so I can see what their other characteristics are. I want the score on the last-named test, but I might also want to know their gender, age, the date they took the test, and so on.
I don’t know how many sets of Test/Score values there may be. The users may have a combination of two or three, or there might be more. I have no problem setting a reasonable limit on the number of sets of values they use, but the whole point is, there will be more than one.
As you might guess, I’m new to Qlikview. I know this will use set analysis, but I’m unsure of the best way to go about it. If you have any ideas, please reply—thanks!
