topic Create a Matrix based on Table in QlikView

Create a Matrix based on Table

Thu, 17 Nov 2016 17:25:39 GMT

Hi people,

Using Qlikview is possible to transform a table like that:

ID	A	B
1	15	30
2	20	43

Into this:

ID	TEST	GRADE
1	A	15
1	B	30
2	A	20
2	B	43

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

Re: Create a Matrix based on Table

hectorvega — Thu, 17 Nov 2016 17:47:14 GMT

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

kaushiknsolanki — Thu, 17 Nov 2016 17:50:07 GMT

Hi,

Yes its possible. You can use the Crosstable Function.

Data:

CROSSTABLE(Test,Grade,1)

Load ID,

From Xyz;

Regards,

Kaushik Solanki