topic Re: Multiple Fields with same values in Pivot Table in QlikView

Multiple Fields with same values in Pivot Table

Mon, 12 Sep 2016 15:47:02 GMT

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:

Students:
LOAD Names
FROM 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?

Many thanks!

sunny_talwar — Mon, 12 Sep 2016 15:50:16 GMT

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 — Mon, 12 Sep 2016 15:50:33 GMT

Use

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

Mon, 12 Sep 2016 16:16:42 GMT

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 — Mon, 12 Sep 2016 16:21:41 GMT

You can use a mapping load to anonymize your data