Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a Matrix based on Table

Hi people,

Using Qlikview is possible to transform a table like that:

 

      IDAB
11530
22043

Into this:

 

IDTESTGRADE
1A15
1B30
2A20
2B43

The represents the student and each A and B a different test... My original database migrate the data in the first format but I needed into the second...

Regards

1 Solution

Accepted Solutions
kaushiknsolanki

Hi,

Yes its possible. You can use the Crosstable Function.

Data:

CROSSTABLE(Test,Grade,1)

Load ID,

        A,

        B

From Xyz;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

2 Replies
hectorvega
Contributor III
Contributor III

Use CrossTable.

You could find a nice video showing how to do it on this url Power of Qlik Script - Reshaping Data with Crosstable (video)

Hope this help.

kaushiknsolanki

Hi,

Yes its possible. You can use the Crosstable Function.

Data:

CROSSTABLE(Test,Grade,1)

Load ID,

        A,

        B

From Xyz;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".