topic How to create a frequency matrix of order complexity in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-frequency-matrix-of-order-complexity/m-p/804149#M283920 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I need some help with the following...</P><P></P><P>I want to create a frequency matrix that shows me the frequency of materials and shipping points used in an order.<BR />By this report I want to meassure the complexity of orders.</P><P>The more shipping points and the more materials used in one order, the more complex the order is.</P><P></P><P>I have added a table (excel) with the orders data.</P><P></P><P>From this table I want to generate a matrix as showed below</P><P><IMG alt="Matrix OrderComplexity.JPG" class="image-1 jive-image" src="/legacyfs/online/79399_Matrix OrderComplexity.JPG" style="height: 298px; width: 620px;" /></P><P>Can anyone help me to build this matrix in QlikView?</P><P></P><P>Regards,</P><P></P><P>Cor</P></BODY></HTML> Fri, 27 Feb 2015 11:24:19 GMT 2015-02-27T11:24:19Z How to create a frequency matrix of order complexity https://community.qlik.com/t5/QlikView/How-to-create-a-frequency-matrix-of-order-complexity/m-p/804149#M283920 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I need some help with the following...</P><P></P><P>I want to create a frequency matrix that shows me the frequency of materials and shipping points used in an order.<BR />By this report I want to meassure the complexity of orders.</P><P>The more shipping points and the more materials used in one order, the more complex the order is.</P><P></P><P>I have added a table (excel) with the orders data.</P><P></P><P>From this table I want to generate a matrix as showed below</P><P><IMG alt="Matrix OrderComplexity.JPG" class="image-1 jive-image" src="/legacyfs/online/79399_Matrix OrderComplexity.JPG" style="height: 298px; width: 620px;" /></P><P>Can anyone help me to build this matrix in QlikView?</P><P></P><P>Regards,</P><P></P><P>Cor</P></BODY></HTML> Fri, 27 Feb 2015 11:24:19 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-frequency-matrix-of-order-complexity/m-p/804149#M283920 2015-02-27T11:24:19Z Re: How to create a frequency matrix of order complexity https://community.qlik.com/t5/QlikView/How-to-create-a-frequency-matrix-of-order-complexity/m-p/804150#M283921 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Fri, 27 Feb 2015 15:15:08 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-frequency-matrix-of-order-complexity/m-p/804150#M283921 Gysbert_Wassenaar 2015-02-27T15:15:08Z Re: How to create a frequency matrix of order complexity https://community.qlik.com/t5/QlikView/How-to-create-a-frequency-matrix-of-order-complexity/m-p/804151#M283922 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>This did worked out perfectly.</P><P>Thanks for you help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards,</P><P></P><P>Cor</P></BODY></HTML> Fri, 27 Feb 2015 15:46:05 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-frequency-matrix-of-order-complexity/m-p/804151#M283922 2015-02-27T15:46:05Z