Migration Matrix in Qlikview

[devarasu07]

Hi All,

I have requirement like Matrix layout output, how to achieve this in qlikview? Thanks

Source file
Date	Customer	Rating
31/08/2016	A	10
31/08/2016	B	10
31/08/2016	C	5
31/08/2016	D	5
31/08/2016	E	10
31/08/2016	F	10
31/08/2016	G	10
31/08/2016	H	4
31/08/2016	I	6
31/07/2016	A	8
31/07/2016	B	2
31/07/2016	C	3
31/07/2016	D	3
31/07/2016	E	8
31/07/2016	F	8
31/07/2016	G	8
31/07/2016	H	10
31/07/2016	I	7

Note:
Grade	customer count
Previous Month	always show the previous month as top of the migration matrix e.x: 31/Jul/2016
Current Month	Current month to be shown in left of the matrix e.x: 31/Aug/2016

Thanks dev

[Anil_Babu_Samineni]

Would you provide application.

OR Do transpose after creating PIVOT

[sunny_talwar · Accepted solution]

Like this?