Displaying How Many "Misses" in a Chart

Tue, 23 Mar 2010 21:15:50 GMT

My data here corresponds to Kindergarten screening in our school, where pre-K students are evaluated on their ability to recognize letters.

So I have student data coming in, with a field titled MissedCapitalA, that can have a value of either 'y' or 'n'. ('y' if they missed it, 'n' if they didn't.)

I also have the same kind of fields for each letter in the alphabet (MissedCapitalB, MissedCapitalC, ..., MissedCapitalZ).

I'd like to create a chart, with the count of missed letters, (all fields with values = 'y' basically), for each letter, along the x-axis (dimension), and the total number of students who were tested on the y-axis (expression).

Any ideas? Thank You.

Also, I do have a StudentNumber for each student, and I'm trying to use a numeric count of StudentNumber as my Expression for the chart.

Displaying How Many "Misses" in a Chart

Oleg_Troyansky — Tue, 23 Mar 2010 22:06:59 GMT

Andrew,

your best option, in my opinion, is to use CROSSTABLE load and transform all your separate fields b letter into a set of two fields - "Letter Missed" and "Missed Flag". You can also transform your "Y" into 1 and "N" into 0. This way, the chart becomes trivial - your dimension will be "Letter Missted" and the expression will be "Sum([Missted Flag])"

good luck!

topic Displaying How Many "Misses" in a Chart in QlikView

Displaying How Many "Misses" in a Chart

Displaying How Many "Misses" in a Chart