Charting Exams over time

Fri, 23 Oct 2009 02:46:57 GMT

HI All,

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?

Thanks!

Charting Exams over time

johnw — Fri, 23 Oct 2009 07:12:53 GMT

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.

topic Charting Exams over time in QlikView

Charting Exams over time

Charting Exams over time