Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

Tags (2)
1 Solution

Accepted Solutions

Re: Create a Matrix based on Table

Hi,

Yes its possible. You can use the Crosstable Function.

Data:

CROSSTABLE(Test,Grade,1)

Load ID,

        A,

        B

From Xyz;

Regards,

Kaushik Solanki

View solution in original post

2 Replies
hectorvega
New Contributor III

Re: Create a Matrix based on Table

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.

Re: Create a Matrix based on Table

Hi,

Yes its possible. You can use the Crosstable Function.

Data:

CROSSTABLE(Test,Grade,1)

Load ID,

        A,

        B

From Xyz;

Regards,

Kaushik Solanki

View solution in original post