I'm very new to QlikView so excuse me if this is a novice question.
I am trying to get a chart that displays the count of specific Tests taken during a certain time frame.
I have three tables:
User - Person taking the test
Test - Name and details of a certain test
UserTest - Instance of a User taking a Test
I am able to create a chart that shows total Tests taken by month no problem. But how do I create a chart that would show counts of the number of tests taken during a specific time frame as well? So I'd like to see than in Jan, test 1 was taken 20 times, test 2 30 times, etc etc.
I have the Title of the Test as the Dimension, but I'm not sure what my Expression should be?
Create a pivot table with dimensions Month and Test Title, and expression count("UserTest ID") or whatever your unique ID on the UserTest table is. Move one or the other dimension to the top to get a two dimensional table. I *think* that's what you're looking for.
