topic Re: Pivot calculations in App Development https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133737#M19922 <HTML><HEAD></HEAD><BODY><P>Does the attached sample meets your requirement?</P></BODY></HTML> Tue, 26 Jul 2016 11:12:41 GMT sunny_talwar 2016-07-26T11:12:41Z Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133731#M19916 <HTML><HEAD></HEAD><BODY><P>We have 3 customers showing in the table. we want to show each customers sales in a column, then a total column for those customers.</P><P>We another column to show the 3 remaining customer totals and the last column needs to be a total of all customers.</P><P>Any help would be great...</P><P></P><P>Thanks</P></BODY></HTML> Sun, 24 Jul 2016 19:27:54 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133731#M19916 deerhunter 2016-07-24T19:27:54Z Re: Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133732#M19917 <HTML><HEAD></HEAD><BODY><P>What would be the required output, can you provide that in an Excel file?</P></BODY></HTML> Sun, 24 Jul 2016 20:18:14 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133732#M19917 sunny_talwar 2016-07-24T20:18:14Z Re: Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133733#M19918 <HTML><HEAD></HEAD><BODY><P><IMG alt="Calculated Sample output.JPG" class="jive-image image-1" src="/legacyfs/online/132392_Calculated Sample output.JPG" style="height: 113px; width: 620px;" /></P></BODY></HTML> Mon, 25 Jul 2016 21:03:46 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133733#M19918 deerhunter 2016-07-25T21:03:46Z Re: Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133734#M19919 <HTML><HEAD></HEAD><BODY><P>I guess I don't understand what is<STRONG> Customer A, Customer B, Customer C.</STRONG></P><P>You measures are just some variation of Sum(SalesAmount). Is this just a sample?</P></BODY></HTML> Mon, 25 Jul 2016 22:57:46 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133734#M19919 sunny_talwar 2016-07-25T22:57:46Z Re: Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133735#M19920 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132403_Capture.PNG" style="height: 99px; width: 620px;" /></P></BODY></HTML> Mon, 25 Jul 2016 23:18:26 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133735#M19920 sunny_talwar 2016-07-25T23:18:26Z Re: Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133736#M19921 <HTML><HEAD></HEAD><BODY><P>Yes just a sample</P></BODY></HTML> Mon, 25 Jul 2016 23:44:45 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133736#M19921 deerhunter 2016-07-25T23:44:45Z Re: Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133737#M19922 <HTML><HEAD></HEAD><BODY><P>Does the attached sample meets your requirement?</P></BODY></HTML> Tue, 26 Jul 2016 11:12:41 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133737#M19922 sunny_talwar 2016-07-26T11:12:41Z Re: Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133738#M19923 <HTML><HEAD></HEAD><BODY><P>Sorry i don't see your Corrected App. Did you attach it?</P></BODY></HTML> Wed, 27 Jul 2016 20:52:41 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133738#M19923 deerhunter 2016-07-27T20:52:41Z Re: Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133739#M19924 <HTML><HEAD></HEAD><BODY><P>Thank you that is perfect <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 29 Jul 2016 13:57:18 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133739#M19924 deerhunter 2016-07-29T13:57:18Z Re: Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133740#M19925 <HTML><HEAD></HEAD><BODY><P>If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).</P><P>If not, please make clear what part of this topic you still need help with <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P></BODY></HTML> Fri, 29 Jul 2016 14:23:18 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133740#M19925 oknotsen 2016-07-29T14:23:18Z Re: Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133741#M19926 <HTML><HEAD></HEAD><BODY><P>How does this work?</P><P>With 6&nbsp; customers in this sample, </P><P>1) What does the dim&nbsp; inline load actually do?</P><P>2) How does it know what to sum?</P><P>&nbsp;&nbsp;&nbsp; You built A pick column statement where dim values are 1 through 4,</P><P>&nbsp;&nbsp;&nbsp; You have 4 sum statements within each measure, two are the same, the third is the same accept for "-=" and the last sum for all. ?????</P><P></P><P>My brain is hurting, help me OB1!</P></BODY></HTML> Fri, 29 Jul 2016 18:29:21 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133741#M19926 deerhunter 2016-07-29T18:29:21Z Re: Pivot calculations https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133742#M19927 <HTML><HEAD></HEAD><BODY><P>Sure but i can't find where that button is to pick it. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Fri, 29 Jul 2016 18:32:49 GMT https://community.qlik.com/t5/App-Development/Pivot-calculations/m-p/1133742#M19927 deerhunter 2016-07-29T18:32:49Z