topic Re: Re: Totaling multiples invoice lines of the same code in QlikView https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596692#M1114918 <HTML><HEAD></HEAD><BODY><P>Hi Manish</P><P></P><P>I do not expect you to do this all for me. I would just like to know the calculation / expression I need to enter to total up the sales volume of each code. My selections based on year and month should break down the totals as required.</P><P></P><P>Regards Steve</P></BODY></HTML> Tue, 18 Feb 2014 09:50:57 GMT 2014-02-18T09:50:57Z Totaling multiples invoice lines of the same code https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596687#M1114913 <HTML><HEAD></HEAD><BODY><P>Good afternoon</P><P></P><P>I am very new to QlikView and have hit a stumbling block already.</P><P></P><P>I have a simple group of 3 linked tables - InvLines, Product and Calendar. the InvLines and Product table are linked by the Product Code and the Calendar table links to the date on the InvLines table.</P><P></P><P>I have managed to create my list boxes with my years, months and qtrs on. I have also created a table with all the necessary data in it.</P><P></P><P>I now want to create a graph so that I can compare the sales volume total for each product code by month, LY vs TY, as well as by Group and Sub Group.</P><P></P><P>My problem is working out how to total the sales volume for each product and then using those figures to give sales volumes by Group and Sub Group.</P><P></P><P>I have a feeling it should be a fairly simple calculation but it's not making sense. I can total the number of invoice lines per code but not the quantity.</P><P></P><P>Any help would be greatly appreciated. Please keep the steps simple so I can follow the process through.</P><P></P><P>Many thanks</P><P></P><P>Steve</P></BODY></HTML> Mon, 17 Feb 2014 16:05:51 GMT https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596687#M1114913 2014-02-17T16:05:51Z Re: Totaling multiples invoice lines of the same code https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596688#M1114914 <HTML><HEAD></HEAD><BODY><P>Can you load your sample apps?</P></BODY></HTML> Mon, 17 Feb 2014 16:10:45 GMT https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596688#M1114914 MK_QSL 2014-02-17T16:10:45Z Re: Re: Totaling multiples invoice lines of the same code https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596689#M1114915 <HTML><HEAD></HEAD><BODY><P>Hi Manish</P><P></P><P>Is it the QVW file you are asking about?</P><P></P><P>Regards</P><P></P><P>Steve</P></BODY></HTML> Mon, 17 Feb 2014 16:15:20 GMT https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596689#M1114915 2014-02-17T16:15:20Z Re: Totaling multiples invoice lines of the same code https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596690#M1114916 <HTML><HEAD></HEAD><BODY><P>Yes.. You can reduce data or create a dummy data with you objects..</P><P>This will help a lot to solve the problem quickly.</P></BODY></HTML> Mon, 17 Feb 2014 16:25:25 GMT https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596690#M1114916 MK_QSL 2014-02-17T16:25:25Z Re: Re: Totaling multiples invoice lines of the same code https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596691#M1114917 <HTML><HEAD></HEAD><BODY><P>Hi Manish</P><P></P><P>File attached. I'll be honest not too sure how to reduce the file size down.</P><P></P><P>Regards</P><P></P><P>Steve</P></BODY></HTML> Mon, 17 Feb 2014 16:31:13 GMT https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596691#M1114917 2014-02-17T16:31:13Z Re: Re: Totaling multiples invoice lines of the same code https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596692#M1114918 <HTML><HEAD></HEAD><BODY><P>Hi Manish</P><P></P><P>I do not expect you to do this all for me. I would just like to know the calculation / expression I need to enter to total up the sales volume of each code. My selections based on year and month should break down the totals as required.</P><P></P><P>Regards Steve</P></BODY></HTML> Tue, 18 Feb 2014 09:50:57 GMT https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596692#M1114918 2014-02-18T09:50:57Z Re: Totaling multiples invoice lines of the same code https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596693#M1114919 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Anyone any ideas as to how I do this?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 18 Feb 2014 16:34:57 GMT https://community.qlik.com/t5/QlikView/Totaling-multiples-invoice-lines-of-the-same-code/m-p/596693#M1114919 2014-02-18T16:34:57Z