topic Function for capture date 1 week before. in App Development https://community.qlik.com/t5/App-Development/Function-for-capture-date-1-week-before/m-p/1282537#M26784 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have dashboard weekly reporting, and the simple table is below:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Service Quality</TH></TR><TR><TD style="padding: 2px;">01/01/17</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">02/01/17</TD><TD style="padding: 2px;">13</TD></TR><TR><TD style="padding: 2px;">03/01/17</TD><TD style="padding: 2px;">33</TD></TR><TR><TD style="padding: 2px;">04/01/17</TD><TD style="padding: 2px;">43</TD></TR><TR><TD style="padding: 2px;">05/01/17</TD><TD style="padding: 2px;">72</TD></TR><TR><TD>06/01/17</TD><TD>11</TD></TR><TR><TD>07/01/17</TD><TD>47</TD></TR><TR><TD>08/01/17</TD><TD>67</TD></TR><TR><TD>09/01/17</TD><TD>21</TD></TR><TR><TD>10/01/17</TD><TD>52</TD></TR></TBODY></TABLE><P><STRONG>Today : 11/01/17 (for example)</STRONG></P><P></P><P>- I want to create a bar chart, but only for 1 week before (04/01/17 - 10/01/17).</P><P></P><P>I already tried function on this link: <A href="https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/DateAndTimeFunctions.htm" title="https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/DateAndTimeFunctions.htm">https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/DateAndTimeFunctions.htm</A>, but no function meet with my question.</P><P></P><P>Thank You.</P></BODY></HTML> Tue, 14 Mar 2017 00:48:55 GMT 2017-03-14T00:48:55Z Function for capture date 1 week before. https://community.qlik.com/t5/App-Development/Function-for-capture-date-1-week-before/m-p/1282537#M26784 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have dashboard weekly reporting, and the simple table is below:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Service Quality</TH></TR><TR><TD style="padding: 2px;">01/01/17</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">02/01/17</TD><TD style="padding: 2px;">13</TD></TR><TR><TD style="padding: 2px;">03/01/17</TD><TD style="padding: 2px;">33</TD></TR><TR><TD style="padding: 2px;">04/01/17</TD><TD style="padding: 2px;">43</TD></TR><TR><TD style="padding: 2px;">05/01/17</TD><TD style="padding: 2px;">72</TD></TR><TR><TD>06/01/17</TD><TD>11</TD></TR><TR><TD>07/01/17</TD><TD>47</TD></TR><TR><TD>08/01/17</TD><TD>67</TD></TR><TR><TD>09/01/17</TD><TD>21</TD></TR><TR><TD>10/01/17</TD><TD>52</TD></TR></TBODY></TABLE><P><STRONG>Today : 11/01/17 (for example)</STRONG></P><P></P><P>- I want to create a bar chart, but only for 1 week before (04/01/17 - 10/01/17).</P><P></P><P>I already tried function on this link: <A href="https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/DateAndTimeFunctions.htm" title="https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/DateAndTimeFunctions.htm">https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/DateAndTimeFunctions.htm</A>, but no function meet with my question.</P><P></P><P>Thank You.</P></BODY></HTML> Tue, 14 Mar 2017 00:48:55 GMT https://community.qlik.com/t5/App-Development/Function-for-capture-date-1-week-before/m-p/1282537#M26784 2017-03-14T00:48:55Z Re: Function for capture date 1 week before. https://community.qlik.com/t5/App-Development/Function-for-capture-date-1-week-before/m-p/1282538#M26785 <HTML><HEAD></HEAD><BODY><P>create flags in load sript using week() function</P><P></P><P><A href="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/week.htm" style="font-size: 10pt;" title="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/week.htm">https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/week.htm</A></P><P></P><P>Then in set analysis restrict the week number you want to show data for for example MaX(WeekNum)-1&nbsp; !!</P></BODY></HTML> Tue, 14 Mar 2017 08:23:36 GMT https://community.qlik.com/t5/App-Development/Function-for-capture-date-1-week-before/m-p/1282538#M26785 vinieme12 2017-03-14T08:23:36Z