Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Fields with same values in Pivot Table

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:

 

JohnPeterCarrizoStewart
ABAC
BCCD
AAAB
CCAC


Students:
LOAD Names
FROM file;

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

 

ABCD
John2110
Peter1110
Carrizo3010
Stewart0111

 

How can I do this in Qlikview?

Many thanks!

1 Solution

Accepted Solutions
sunny_talwar

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);

Capture.PNG

View solution in original post

4 Replies
sunny_talwar

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);

Capture.PNG

swuehl
MVP
MVP

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

Not applicable
Author

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