topic How to calculate last seven days update dates from date field in App Development

topic How to calculate last seven days update dates from date field in App Development https://community.qlik.com/t5/App-Development/How-to-calculate-last-seven-days-update-dates-from-date-field/m-p/1694309#M53105 <P>Hi Qlik experts,</P><P>I am troubling with my new scenario. it is below:</P><P>I have a table  with column names like Strategy Name and Last update and Business date.</P><P>my scenario is: <STRONG>I want show how many rows are updated in last seven days.</STRONG></P><P>Example: </P><TABLE width="330"><TBODY><TR><TD width="110">Internal Strategy Name</TD><TD width="110">Last Update</TD><TD width="110">Business date</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">09/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">09/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">03/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">13/03/2020</FONT></TD><TD>04/12/2017</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">13/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">17/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">05/12/2019</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">05/12/2019</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">05/12/2019</FONT></TD><TD>01/03/2019</TD></TR></TBODY></TABLE><P> </P><P>Output:</P><TABLE width="325"><TBODY><TR><TD width="153">Internal Strategy Name</TD><TD width="79">Last Update</TD><TD width="93">Business date</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST-1</TD><TD>06/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD>06/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST-1</TD><TD>06/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD>06/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD>09/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD>03/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST-1</TD><TD>13/03/2020</TD><TD>04/12/2017</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD>17/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST-1</TD><TD>05/12/2019</TD><TD>01/03/2019</TD></TR></TBODY></TABLE><P> </P><P>Quick replay will be more appreciate guys..</P><P>Please provide me a proper solutions for that.</P><P> </P><P>Thanks in Advance..!!!!</P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P> Fri, 17 Apr 2020 05:18:58 GMT manojkumar_mk 2020-04-17T05:18:58Z How to calculate last seven days update dates from date field https://community.qlik.com/t5/App-Development/How-to-calculate-last-seven-days-update-dates-from-date-field/m-p/1694309#M53105 <P>Hi Qlik experts,</P><P>I am troubling with my new scenario. it is below:</P><P>I have a table  with column names like Strategy Name and Last update and Business date.</P><P>my scenario is: <STRONG>I want show how many rows are updated in last seven days.</STRONG></P><P>Example: </P><TABLE width="330"><TBODY><TR><TD width="110">Internal Strategy Name</TD><TD width="110">Last Update</TD><TD width="110">Business date</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">06/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">09/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">09/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">03/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">13/03/2020</FONT></TD><TD>04/12/2017</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">13/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">17/03/2020</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">05/12/2019</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">05/12/2019</FONT></TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD><FONT color="#800000">05/12/2019</FONT></TD><TD>01/03/2019</TD></TR></TBODY></TABLE><P> </P><P>Output:</P><TABLE width="325"><TBODY><TR><TD width="153">Internal Strategy Name</TD><TD width="79">Last Update</TD><TD width="93">Business date</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST-1</TD><TD>06/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD>06/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST-1</TD><TD>06/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD>06/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD>09/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD>03/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST-1</TD><TD>13/03/2020</TD><TD>04/12/2017</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD>17/03/2020</TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST</TD><TD> </TD><TD>01/03/2019</TD></TR><TR><TD>MANOJ-TEST-1</TD><TD>05/12/2019</TD><TD>01/03/2019</TD></TR></TBODY></TABLE><P> </P><P>Quick replay will be more appreciate guys..</P><P>Please provide me a proper solutions for that.</P><P> </P><P>Thanks in Advance..!!!!</P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P><P> </P> Fri, 17 Apr 2020 05:18:58 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-last-seven-days-update-dates-from-date-field/m-p/1694309#M53105 manojkumar_mk 2020-04-17T05:18:58Z