Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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!

Tags (1)
1 Solution

Accepted Solutions

Re: Multiple Fields with same values in Pivot Table

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

4 Replies

Re: Multiple Fields with same values in Pivot Table

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

MVP
MVP

Re: Multiple Fields with same values in Pivot Table

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

Re: Multiple Fields with same values in Pivot Table

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?

Re: Multiple Fields with same values in Pivot Table

You can use a mapping load to anonymize your data

Don't join - use Applymap instead