topic Re: migration matrix in QlikView https://community.qlik.com/t5/QlikView/migration-matrix/m-p/1081006#M523503 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Count(PARTNER)/Count(TOTAL &lt;SCORING_CURR&gt;PARTNER)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121005_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Fri, 08 Apr 2016 11:08:19 GMT sunny_talwar 2016-04-08T11:08:19Z migration matrix https://community.qlik.com/t5/QlikView/migration-matrix/m-p/1081005#M523502 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Today I have very simple case, I have table with only 3 columns (attach xlsx).</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 248px;"><TBODY><TR><TD class="xl66" height="15" width="72">PARTNER</TD><TD class="xl66" width="87">SCORING_CURR</TD><TD class="xl66" width="89">SCORING_FWRD</TD></TR><TR><TD class="xl65" height="15">PARTNER_82</TD><TD align="right" class="xl65">2</TD><TD align="right" class="xl64">3</TD></TR><TR><TD class="xl65" height="15">PARTNER_82</TD><TD align="right" class="xl65">2</TD><TD align="right" class="xl64">2</TD></TR><TR><TD class="xl65" height="15">PARTNER_82</TD><TD align="right" class="xl65">2</TD><TD align="right" class="xl64">2</TD></TR><TR><TD class="xl65" height="15">PARTNER_82</TD><TD align="right" class="xl65">3</TD><TD align="right" class="xl64">2</TD></TR><TR><TD class="xl65" height="15">PARTNER_82</TD><TD align="right" class="xl65">3</TD><TD align="right" class="xl64">3</TD></TR><TR><TD class="xl65" height="15">PARTNER_82</TD><TD align="right" class="xl65">3</TD><TD align="right" class="xl64">3</TD></TR><TR><TD class="xl65" height="15">PARTNER_82</TD><TD align="right" class="xl65">3</TD><TD align="right" class="xl64">3</TD></TR><TR><TD class="xl65" height="15">PARTNER_82</TD><TD align="right" class="xl65">3</TD><TD align="right" class="xl64">3</TD></TR></TBODY></TABLE><P></P><P>I need to create a pivot tables with % of partners quatities:</P><P><IMG alt="Przechwytywanie.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121027_Przechwytywanie.PNG" style="height: auto;" /></P><P>Any suggestions.</P></BODY></HTML> Fri, 08 Apr 2016 10:55:00 GMT https://community.qlik.com/t5/QlikView/migration-matrix/m-p/1081005#M523502 arsenal1983 2016-04-08T10:55:00Z Re: migration matrix https://community.qlik.com/t5/QlikView/migration-matrix/m-p/1081006#M523503 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Count(PARTNER)/Count(TOTAL &lt;SCORING_CURR&gt;PARTNER)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121005_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Fri, 08 Apr 2016 11:08:19 GMT https://community.qlik.com/t5/QlikView/migration-matrix/m-p/1081006#M523503 sunny_talwar 2016-04-08T11:08:19Z Re: migration matrix https://community.qlik.com/t5/QlikView/migration-matrix/m-p/1081007#M523504 <HTML><HEAD></HEAD><BODY><P>you truly are a legend <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 08 Apr 2016 11:16:18 GMT https://community.qlik.com/t5/QlikView/migration-matrix/m-p/1081007#M523504 arsenal1983 2016-04-08T11:16:18Z Re: migration matrix https://community.qlik.com/t5/QlikView/migration-matrix/m-p/1081008#M523505 <HTML><HEAD></HEAD><BODY><P>I am glad I was able to help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 08 Apr 2016 11:41:45 GMT https://community.qlik.com/t5/QlikView/migration-matrix/m-p/1081008#M523505 sunny_talwar 2016-04-08T11:41:45Z