Discussion Board for collaboration related to Creating Analytics for QlikView.
Imagine that I have the following table that shows the name of some students as column name and his grades on a test as values:
Students:LOAD NamesFROM file;
I only have four grandes and I want to obtain the count of grades of each student like this:
How can I do this in Qlikview?
Go to Solution.
May be use a CrossTable load
(html, codepage is 1252, embedded labels, table is @1);
The Crosstable Load
to transform your table from a cross table to a straight table (using an additional Recno() field as qualifying field).
Then use Name and Grade as dimensions in a pivot table chart and
Hi Sunny T, many thanks! Only one more question:
If I want to show in the table names instead of students , for example instead of John I want to appear "Student A". How can I do this?
You can use a mapping load to anonymize your data
Don't join - use Applymap instead