Multiple Fields with same values in Pivot Table

[#1]

Hi,

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:

John	Peter	Carrizo	Stewart
A	B	A	C
B	C	C	D
A	A	A	B
C	C	A	C

Students:
LOAD Names
FROM file;

I only have four grandes and I want to obtain the count of grades of each student like this:

	A	B	C	D
John	2	1	1	0
Peter	1	1	1	0
Carrizo	3	0	1	0
Stewart	0	1	1	1

How can I do this in Qlikview?

Many thanks!

[sunny_talwar · Accepted solution]

May be use a CrossTable load

Table:

CrossTable(Name, Grade)

LOAD 1,

  John,

    Peter,

    Carrizo,

    Stewart

FROM

[https://community.qlik.com/thread/232385]

(html, codepage is 1252, embedded labels, table is @1);

[swuehl]

Use

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

=Count(Name)

as expression

[#4]

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?

[sunny_talwar]

You can use a mapping load to anonymize your data

Don't join - use Applymap instead