topic Re: How to Sum Total for Week in Group? in QlikView https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217614#M872924 <HTML><HEAD></HEAD><BODY><P>Hi Marcio,</P><P></P><P>I am new to Qlikview, would you please collaborate?</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 09 Nov 2016 19:41:09 GMT 2016-11-09T19:41:09Z How to Sum Total for Week in Group? https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217610#M872920 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need to sum up the calls for each week and the total for the week needs to remain even if I select month, year, date etc... The sum total only gives me the grand total.</P><P></P><P>The week is active so the result of call offered is what I need in the new column. Would someone please show me how to achieve this?</P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143315_1.png" style="height: auto;" /></P><P></P><P>Thank you for your help everyone.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217610#M872920 2020-11-25T16:16:04Z Re: How to Sum Total for Week in Group? https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217611#M872921 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be try this:</P><P></P><P>Sum(Total&lt;[Day of Week]&gt; count)</P><P></P><P>So use the week dimension within Total&lt;&gt;.</P><P></P><P>Hope this helps.</P></BODY></HTML> Tue, 08 Nov 2016 21:15:14 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217611#M872921 sinanozdemir 2016-11-08T21:15:14Z Re: How to Sum Total for Week in Group? https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217612#M872922 <HTML><HEAD></HEAD><BODY><P>Hi Sinan,</P><P></P><P>It does not matter what I put in &lt; &gt;, it still show the grand total, 558,033, for result. Do you have other idea? Thank you for your input.</P></BODY></HTML> Wed, 09 Nov 2016 17:43:46 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217612#M872922 2016-11-09T17:43:46Z Re: How to Sum Total for Week in Group? https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217613#M872923 <HTML><HEAD></HEAD><BODY><P>You can use the WeekStart function:</P><P>Ex: WeekStart(field date)</P></BODY></HTML> Wed, 09 Nov 2016 18:28:57 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217613#M872923 Anonymous 2016-11-09T18:28:57Z Re: How to Sum Total for Week in Group? https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217614#M872924 <HTML><HEAD></HEAD><BODY><P>Hi Marcio,</P><P></P><P>I am new to Qlikview, would you please collaborate?</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 09 Nov 2016 19:41:09 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217614#M872924 2016-11-09T19:41:09Z Re: How to Sum Total for Week in Group? https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217615#M872925 <HTML><HEAD></HEAD><BODY><P>Can you share some sample data and define what out you expect...</P></BODY></HTML> Wed, 09 Nov 2016 19:50:43 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217615#M872925 neelamsaroha157 2016-11-09T19:50:43Z Re: How to Sum Total for Week in Group? https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217616#M872926 <HTML><HEAD></HEAD><BODY><P>phong do,</P><P></P><P>Can you send an example to try to help you?</P></BODY></HTML> Wed, 09 Nov 2016 19:50:58 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-Total-for-Week-in-Group/m-p/1217616#M872926 Anonymous 2016-11-09T19:50:58Z