topic Re: Order vs Receipt Details in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641878#M1086797 <HTML><HEAD></HEAD><BODY><P>nope</P></BODY></HTML> Fri, 06 Jun 2014 07:13:22 GMT 2014-06-06T07:13:22Z Order vs Receipt Details in Pivot Table https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641869#M1086785 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I am working on ' Inventory &amp; Production' application for a client. There is a requirement to show details for order vs receipt in a pivot table. In this case two tables are there, one for Header and other one for line detail. </P><P></P><P>In header table, customer raise a PO for placing a order for required qty as a bulk order and in line table he receives qty on multiple times against supply.</P><P></P><P>For Ex;</P><P>Hear Table</P><P>----------------</P><P></P><P>Po No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Order Qty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vendor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item</P><P>------------------------------------------------------------------------------------------------------</P><P>PO10245&nbsp;&nbsp;&nbsp;&nbsp; 01/05/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52104&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACB5044</P><P>PO12548&nbsp;&nbsp;&nbsp;&nbsp; 05/05/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 84501&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACV5042&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>And When customer receives supply against order, entries in Line Table is as follows:</P><P>Line Table</P><P>-------------</P><P>Po No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Supply Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rec Qty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Vendor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRN No</P><P>-----------------------------------------------------------------------------------------------------------------------------------</P><P>PO10245&nbsp;&nbsp;&nbsp;&nbsp; 08/05/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52104&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACB5044&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRN10104</P><P>PO10245&nbsp;&nbsp;&nbsp;&nbsp; 18/05/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52104&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACB5044&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRN10143</P><P>PO10245&nbsp;&nbsp;&nbsp;&nbsp; 21/05/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52104&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACB5044&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRN11108</P><P>PO12548&nbsp;&nbsp;&nbsp;&nbsp; 15/05/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 84501&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACV5042&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRN11110</P><P>PO12548&nbsp;&nbsp;&nbsp;&nbsp; 20/05/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 84501&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACV5042&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRN11111</P><P></P><P>-------------------------------------------------------------------------------------------------------------------------------------</P><P></P><P>And output Required in following format in Pivot Table:</P><P></P><P>Vendor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Po No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GrNNo&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Order Qty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Received Qty</P><P>------------------------------------------------------------------------------------------------------------------------------------</P><P> Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 320 </P><P>------------------------------------------------------------------------------------------------------------------------------------</P><P>52104&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO10245&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACB5044&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRN10104&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRN10143&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRN11108&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 111</P><P>----------------------------------------------------------------------------------------------------------------------------------</P><P>Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P>----------------------------------------------------------------------------------------------------------------------------------</P><P>84501&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PO12548&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACV5042&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRN11110&nbsp;&nbsp;&nbsp; 700&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRN11111&nbsp;&nbsp;&nbsp;&nbsp; 700&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>----------------------------------------------------------------------------------------------------------------------------------</P><P></P><P></P><P>Please suggest me a solution so that I can fulfill client requirement.&nbsp; </P><P>Awaiting for your suggestions.(High Priority Requirement) </P><P></P><P>Thanks in Advance</P></BODY></HTML> Fri, 06 Jun 2014 03:35:07 GMT https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641869#M1086785 2014-06-06T03:35:07Z Re: Order vs Receipt Details in Pivot Table https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641870#M1086786 <HTML><HEAD></HEAD><BODY><P>Hi Aman,</P><P></P><P>find the attachment, hope this will help you</P><P></P><P></P><P>-- Rajendra</P></BODY></HTML> Fri, 06 Jun 2014 04:46:14 GMT https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641870#M1086786 2014-06-06T04:46:14Z Re: Order vs Receipt Details in Pivot Table https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641871#M1086788 <HTML><HEAD></HEAD><BODY><P>PFA.</P></BODY></HTML> Fri, 06 Jun 2014 05:37:45 GMT https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641871#M1086788 senpradip007 2014-06-06T05:37:45Z Re: Order vs Receipt Details in Pivot Table https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641872#M1086789 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Fri, 06 Jun 2014 06:27:11 GMT https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641872#M1086789 adarsh_a 2014-06-06T06:27:11Z Re: Order vs Receipt Details in Pivot Table https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641873#M1086791 <HTML><HEAD></HEAD><BODY><P>Dear Pradip,</P><P></P><P>Thanks for providing valuable suggestion for same. But I think it will not work properly because if there will be another PO with Same Order Qty then sum(distinct Order Qty) will show wrong output. </P><P></P><P>If possible please provide more better and feasible solution.</P><P></P><P>Thanks Again</P></BODY></HTML> Fri, 06 Jun 2014 06:31:36 GMT https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641873#M1086791 2014-06-06T06:31:36Z Re: Re: Order vs Receipt Details in Pivot Table https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641874#M1086793 <HTML><HEAD></HEAD><BODY><P>Please find updated app. Hope it meets your target. </P></BODY></HTML> Fri, 06 Jun 2014 06:37:50 GMT https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641874#M1086793 senpradip007 2014-06-06T06:37:50Z Re: Order vs Receipt Details in Pivot Table https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641875#M1086794 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Because Order Qty of PO is a Measure, so will it better to keep this on Link table in Data Model.</P><P></P><P>If we can join these two tables and can achieve goal then it will much better for us.</P></BODY></HTML> Fri, 06 Jun 2014 06:47:28 GMT https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641875#M1086794 2014-06-06T06:47:28Z Re: Order vs Receipt Details in Pivot Table https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641876#M1086795 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi,</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Because Order Qty of PO is a Measure, so will it better to keep this on Link table in Data Model.</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If we can join these two tables and can achieve goal then it will much better for us.</P></BODY></HTML> Fri, 06 Jun 2014 06:47:43 GMT https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641876#M1086795 2014-06-06T06:47:43Z Re: Order vs Receipt Details in Pivot Table https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641877#M1086796 <HTML><HEAD></HEAD><BODY><P>Try the bellow expressions along with the dimensions which you have taken</P><P>Order quantity:&nbsp; <SPAN style="color: #800000; font-size: 8pt;">Sum([Order Qty])</SPAN></P><P>Receivedquantity: <SPAN style="color: #800000; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Rec Qty]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P> </P><P> </P></BODY></HTML> Fri, 06 Jun 2014 07:07:37 GMT https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641877#M1086796 PradeepReddy 2014-06-06T07:07:37Z Re: Order vs Receipt Details in Pivot Table https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641878#M1086797 <HTML><HEAD></HEAD><BODY><P>nope</P></BODY></HTML> Fri, 06 Jun 2014 07:13:22 GMT https://community.qlik.com/t5/QlikView/Order-vs-Receipt-Details-in-Pivot-Table/m-p/641878#M1086797 2014-06-06T07:13:22Z