Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Can ur post ur datasample? then it might be easier to make.
I'm working on that now--thanks!
Here's the data.
Could u sum up what u want to be done? without wall of text Just in bulletpoints maybe?
OK--
For people who have these scores:
TEST01 1800 to 2000
TEST09 600 to 900
TEST11 over 200
What are their scores on TEST04?
Keeping in mind that tomorrow I'll want a whole different set of test names and score ranges.
I have made this for TEST01 and TEST09 - Is it something like this?
If you want the interval to be dynamic i suggest you make a table which maps to your testname and then updates with the rigth intervals.
And then you could update the scores in an excel ark or something like that.
But im not quite sure how to make it. Maybe someone else know
Thanks, Thomas, I'll take a look at this.
Thomas, I really appreciate you giving this a try! But I'm sorry, it's not quite what I had in mind. What I'm looking for is some way to make the query dynamic, allowing the users to choose which tests and what the ranges are on the fly. Also, I wasn't looking for an aggregation of the score, I was looking to find the set of people whose scores fit the criteria.
Anybody else have any ideas?