topic Re: SUM TOTAL and AVG in QlikView https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582986#M478423 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>This does not seem to work.</P><P>below the results of your expressions:</P><P></P><P><IMG alt="code-order-v2.gif" class="jive-image" src="https://community.qlik.com/legacyfs/online/55154_code-order-v2.gif" style="width: 620px; height: 59px;" /></P></BODY></HTML> Mon, 17 Mar 2014 13:29:31 GMT 2014-03-17T13:29:31Z SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582979#M478416 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I need a solution for my problem. I want to use the totals of the tables below for further calculations.</P><P>There must be a solution, but I couldn't find it. I tried AGGR, sum(total &lt;field&gt;), but without result.</P><P><IMG alt="code-order.gif" class="jive-image jiveImage" src="https://community.qlik.com/legacyfs/online/55143_code-order.gif" /></P><P>Order 960 has 5 codes of 30 and order 961 has 1 code of 30.</P><P></P><P>I need the following figures:</P><P>- Total Orderbedrag = 180</P><P>- Avg Orderbedrag = 90</P><P>- Avg Bonbedrag = 30</P><P></P><P>Can you help me with this? </P><P></P><P>Kind regards,</P><P></P><P>Erwin</P></BODY></HTML> Mon, 17 Mar 2014 10:54:49 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582979#M478416 2014-03-17T10:54:49Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582980#M478417 <HTML><HEAD></HEAD><BODY><P>Can you share your sample data please?</P></BODY></HTML> Mon, 17 Mar 2014 10:56:35 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582980#M478417 MK_QSL 2014-03-17T10:56:35Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582981#M478418 <HTML><HEAD></HEAD><BODY><P>Can you share a sample app with small data?</P></BODY></HTML> Mon, 17 Mar 2014 11:01:50 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582981#M478418 2014-03-17T11:01:50Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582982#M478419 <HTML><HEAD></HEAD><BODY><P>Hi Manish and Shyamal,</P><P></P><P>This comes from my DB, so I do not have sample data. Or can I export this to excel?</P><P>kind regards,</P><P></P><P>Erwin</P></BODY></HTML> Mon, 17 Mar 2014 11:12:37 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582982#M478419 2014-03-17T11:12:37Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582983#M478420 <HTML><HEAD></HEAD><BODY><P>Just give us few lines in excel...</P></BODY></HTML> Mon, 17 Mar 2014 11:14:59 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582983#M478420 MK_QSL 2014-03-17T11:14:59Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582984#M478421 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I will add two xls files. Kind regards, Erwin</P></BODY></HTML> Mon, 17 Mar 2014 11:36:29 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582984#M478421 2014-03-17T11:36:29Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582985#M478422 <HTML><HEAD></HEAD><BODY><P>SUM([Order Amount])</P><P></P><P>SUM(TOTAL [Order Amount])/COUNT(TOTAL DISTINCT OrderId) </P><P>or</P><P>SUM([Order Amount])/COUNT(DISTINCT OrderId)</P><P></P><P>Dont have idea about</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;"> Avg Bonbedrag = 30</SPAN></P></BODY></HTML> Mon, 17 Mar 2014 13:10:00 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582985#M478422 MK_QSL 2014-03-17T13:10:00Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582986#M478423 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>This does not seem to work.</P><P>below the results of your expressions:</P><P></P><P><IMG alt="code-order-v2.gif" class="jive-image" src="https://community.qlik.com/legacyfs/online/55154_code-order-v2.gif" style="width: 620px; height: 59px;" /></P></BODY></HTML> Mon, 17 Mar 2014 13:29:31 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582986#M478423 2014-03-17T13:29:31Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582987#M478424 <HTML><HEAD></HEAD><BODY><P>What is the dimension you are using?</P></BODY></HTML> Mon, 17 Mar 2014 13:33:27 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582987#M478424 MK_QSL 2014-03-17T13:33:27Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582988#M478425 <HTML><HEAD></HEAD><BODY><P>It doens't matter if I use orderId or codeId.</P><P>the sum total stays the same.</P></BODY></HTML> Mon, 17 Mar 2014 14:08:17 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582988#M478425 2014-03-17T14:08:17Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582989#M478426 <HTML><HEAD></HEAD><BODY><P>On what basis both tables are linked with each other?</P></BODY></HTML> Mon, 17 Mar 2014 14:46:45 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582989#M478426 MK_QSL 2014-03-17T14:46:45Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582990#M478427 <HTML><HEAD></HEAD><BODY><P><IMG alt="code-order-tableview.gif" class="jive-image" src="https://community.qlik.com/legacyfs/online/55168_code-order-tableview.gif" />I've attached screenshot</P></BODY></HTML> Mon, 17 Mar 2014 17:05:28 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582990#M478427 2014-03-17T17:05:28Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582991#M478428 <HTML><HEAD></HEAD><BODY><P>But you haven't provided proper sample data files !</P></BODY></HTML> Mon, 17 Mar 2014 17:20:20 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582991#M478428 MK_QSL 2014-03-17T17:20:20Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582992#M478429 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>Manish Kachhia schreef:</P> <P></P> <P>Just give us few lines in excel...</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P>I created a few lines in excel, just like you asked...</P><P>This should be enough for the problem, right?</P><P></P><P>Kind regards, Erwin</P></BODY></HTML> Mon, 17 Mar 2014 18:20:16 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582992#M478429 2014-03-17T18:20:16Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582993#M478430 <HTML><HEAD></HEAD><BODY><P>I don't find any common field in your excel files which can link these two tables...</P></BODY></HTML> Tue, 18 Mar 2014 07:54:58 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582993#M478430 MK_QSL 2014-03-18T07:54:58Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582994#M478431 <HTML><HEAD></HEAD><BODY><P>Hi Erwin,</P><P></P><P>I have gone through the thread but it is not clear what exactly your issue is.</P><P>You have to create dummy data or export properly with out put you need.</P><P></P><P>as you mentioned "<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Order 960 has 5 codes of 30 and order 961 has 1 code of 30.</SPAN>" it seems you can create this dummy data in Excel with 3 tabs as tables with output you needed.</P><P></P><P>cheers!!!</P></BODY></HTML> Tue, 18 Mar 2014 10:24:27 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582994#M478431 qlikpahadi07 2014-03-18T10:24:27Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582995#M478432 <HTML><HEAD></HEAD><BODY><P>I uploaded a new file with the connecting ID.</P></BODY></HTML> Tue, 18 Mar 2014 13:38:56 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582995#M478432 2014-03-18T13:38:56Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582996#M478433 <HTML><HEAD></HEAD><BODY><P>Like this?</P></BODY></HTML> Tue, 18 Mar 2014 13:58:07 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582996#M478433 MK_QSL 2014-03-18T13:58:07Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582997#M478434 <HTML><HEAD></HEAD><BODY><P>Sorry I cannot open this document, because I am on personal license...</P></BODY></HTML> Tue, 18 Mar 2014 14:26:20 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582997#M478434 2014-03-18T14:26:20Z Re: SUM TOTAL and AVG https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582998#M478435 <HTML><HEAD></HEAD><BODY><P>Create a Straight Table</P><P>Dimension = Orderid</P><P>Expressions </P><P>SUM(Amount)</P><P>SUM([Order Amount])</P><P>SUM(TOTAL&lt;OrderId&gt; [Order Amount])</P><P>SUM(TOTAL &lt;CodeId,OrderId&gt;[Order Amount])/COUNT(OrderId)</P><P>COUNT(CodeId)</P><P>AVG(Amount)</P></BODY></HTML> Tue, 18 Mar 2014 14:31:35 GMT https://community.qlik.com/t5/QlikView/SUM-TOTAL-and-AVG/m-p/582998#M478435 MK_QSL 2014-03-18T14:31:35Z