topic Re: How to Select Days for Subtotal in QlikView https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27950#M783614 <HTML><HEAD></HEAD><BODY><P>please elaborate the requirement..sample app?</P></BODY></HTML> Wed, 14 Mar 2018 17:20:09 GMT shiveshsingh 2018-03-14T17:20:09Z How to Select Days for Subtotal https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27948#M783612 <HTML><HEAD></HEAD><BODY><P>I have a list of customers with sales data, and i only want to select certain days of the month as a subtotal.&nbsp; The MTD Total continues to show in the Straight Table Total not just the the subtotal of the five days that I selected.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27948#M783612 Anonymous 2020-11-25T16:16:04Z Re: How to Select Days for Subtotal https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27949#M783613 <HTML><HEAD></HEAD><BODY><P>Can you share your data or app? On what criteria/basis we gonna select those days?</P></BODY></HTML> Wed, 14 Mar 2018 17:06:48 GMT https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27949#M783613 isingh30 2018-03-14T17:06:48Z Re: How to Select Days for Subtotal https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27950#M783614 <HTML><HEAD></HEAD><BODY><P>please elaborate the requirement..sample app?</P></BODY></HTML> Wed, 14 Mar 2018 17:20:09 GMT https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27950#M783614 shiveshsingh 2018-03-14T17:20:09Z Re: How to Select Days for Subtotal https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27951#M783616 <HTML><HEAD></HEAD><BODY><P>Hi Patrick,</P><P></P><P>Please find below the expression:-</P><P><SPAN style="color: #0000ff; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum({&lt;Year=, Month=, Quarter=, Week=, DateField=, DateNum={"&gt;=$(=Num(MonthStart(Max(DateNum))))&lt;=$(=Max(DateNum))"}&gt;} Sales)</SPAN></P><P><SPAN style="color: #0000ff; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #0000ff; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Regards,</SPAN></P><P><SPAN style="color: #0000ff; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Ajay<BR /></SPAN></P></BODY></HTML> Wed, 14 Mar 2018 17:21:33 GMT https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27951#M783616 ajaysingh285 2018-03-14T17:21:33Z Re: How to Select Days for Subtotal https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27952#M783619 <HTML><HEAD></HEAD><BODY><P>For this, you need to define the Datenum field too like floor(Date_Field)</P></BODY></HTML> Wed, 14 Mar 2018 17:25:04 GMT https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27952#M783619 shiveshsingh 2018-03-14T17:25:04Z Re: How to Select Days for Subtotal https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27953#M783620 <HTML><HEAD></HEAD><BODY><P>Days selection is based on those days in the week.&nbsp; The issue is that the column totals that appear after selecting those days doesn't change regardless of what or how many days are selected.&nbsp; The column totals remain the month-to-date totals.</P></BODY></HTML> Wed, 14 Mar 2018 18:47:48 GMT https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27953#M783620 Anonymous 2018-03-14T18:47:48Z Re: How to Select Days for Subtotal https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27954#M783621 <HTML><HEAD></HEAD><BODY><P><IMG alt="Qlik.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196406_Qlik.PNG" style="height: 375px; width: 620px;" /></P></BODY></HTML> Wed, 14 Mar 2018 18:52:30 GMT https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27954#M783621 Anonymous 2018-03-14T18:52:30Z Re: How to Select Days for Subtotal https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27955#M783622 <HTML><HEAD></HEAD><BODY><P>Try like this -</P><P></P><P>Sum({$&lt;Month = {Jan},[Days of Month] = {1}&gt;} Sales)</P><P></P><P>Let me know.</P></BODY></HTML> Wed, 14 Mar 2018 20:10:16 GMT https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27955#M783622 isingh30 2018-03-14T20:10:16Z Re: How to Select Days for Subtotal https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27956#M783623 <HTML><HEAD></HEAD><BODY><P>Did not work</P></BODY></HTML> Wed, 14 Mar 2018 20:31:03 GMT https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27956#M783623 Anonymous 2018-03-14T20:31:03Z Re: How to Select Days for Subtotal https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27957#M783624 <HTML><HEAD></HEAD><BODY><P>Please replace sum with only &amp; then try.</P></BODY></HTML> Wed, 14 Mar 2018 22:24:39 GMT https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27957#M783624 isingh30 2018-03-14T22:24:39Z Re: How to Select Days for Subtotal https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27958#M783625 <HTML><HEAD></HEAD><BODY><P>Did not work</P><P></P><P>Patrick Lipscomb | Financial Planning and Analysis Manager | p: 708.623.1916 | www.g-w.com&lt;http://www.g-w.com/&gt;</P><P>G-W Goodheart-Willcox Publisher | Experts in Career and Technical Education | Follow us on Facebook&lt;https://www.facebook.com/GoodheartWillcox&gt;, Twitter&lt;https://twitter.com/gwpublisher&gt;, and LinkedIn&lt;https://www.linkedin.com/company/goodheartwillcox&gt; | #WeBuildCareers</P></BODY></HTML> Thu, 15 Mar 2018 13:20:56 GMT https://community.qlik.com/t5/QlikView/How-to-Select-Days-for-Subtotal/m-p/27958#M783625 Anonymous 2018-03-15T13:20:56Z