topic Re: Migration Matrix in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Migration-Matrix-in-Qlikview/m-p/1183679#M886632 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/137451_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 14 Sep 2016 17:05:20 GMT sunny_talwar 2016-09-14T17:05:20Z Migration Matrix in Qlikview https://community.qlik.com/t5/QlikView/Migration-Matrix-in-Qlikview/m-p/1183677#M886630 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have requirement like Matrix layout output, how to achieve this in qlikview? Thanks</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 223px;"><TBODY><TR><TH style="color: #ffffff; text-align: center; padding: 2px; background-color: #6690bc;">Source file</TH></TR><TR><TD class="xl85" height="20" style="color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Date</TD><TD class="xl85" style="border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Customer</TD><TD class="xl85" style="border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">Rating</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/08/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">A</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/08/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">B</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/08/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">C</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">5</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/08/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">D</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">5</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/08/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">E</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/08/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">F</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/08/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">G</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/08/2016</TD><TD class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">H</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">4</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/08/2016</TD><TD class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">I</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">6</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/07/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">A</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">8</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/07/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">B</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">2</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/07/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">C</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">3</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/07/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">D</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">3</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/07/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">E</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">8</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/07/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">F</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">8</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/07/2016</TD><TD class="xl87" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">G</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">8</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/07/2016</TD><TD class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">H</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">10</TD></TR><TR><TD align="right" class="xl86" height="20" style="border-top-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">31/07/2016</TD><TD class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">I</TD><TD align="right" class="xl84" style="border-top-style: none; border-left-style: none; color: #575757; text-align: left; font-family: arial, helvetica, sans-serif; vertical-align: baseline; background-color: rgba(0, 0, 0, 0);">7</TD></TR></TBODY></TABLE><P></P><P><IMG alt="Matrix.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/137374_Matrix.jpg" style="height: auto;" /></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 618px;"><TBODY><TR><TD height="20" width="106">Note:</TD></TR><TR><TD height="20">Grade</TD><TD colspan="2">customer count</TD></TR><TR><TD class="xl84" height="20">Previous Month</TD><TD colspan="8">always show the previous month as top of the migration matrix e.x: 31/Jul/2016</TD></TR><TR><TD height="20">Current Month</TD><TD colspan="7">Current month to be shown in left of the matrix e.x: 31/Aug/2016</TD></TR></TBODY></TABLE><P></P><P>Thanks dev</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Migration-Matrix-in-Qlikview/m-p/1183677#M886630 devarasu07 2020-11-25T16:16:04Z Re: Migration Matrix in Qlikview https://community.qlik.com/t5/QlikView/Migration-Matrix-in-Qlikview/m-p/1183678#M886631 <HTML><HEAD></HEAD><BODY><P>Would you provide application. </P><P></P><P>OR Do transpose after creating PIVOT</P></BODY></HTML> Wed, 14 Sep 2016 15:54:59 GMT https://community.qlik.com/t5/QlikView/Migration-Matrix-in-Qlikview/m-p/1183678#M886631 Anil_Babu_Samineni 2016-09-14T15:54:59Z Re: Migration Matrix in Qlikview https://community.qlik.com/t5/QlikView/Migration-Matrix-in-Qlikview/m-p/1183679#M886632 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/137451_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 14 Sep 2016 17:05:20 GMT https://community.qlik.com/t5/QlikView/Migration-Matrix-in-Qlikview/m-p/1183679#M886632 sunny_talwar 2016-09-14T17:05:20Z