topic Button Selecting Most Recent 6 Months in QlikView https://community.qlik.com/t5/QlikView/Button-Selecting-Most-Recent-6-Months/m-p/478257#M1122221 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I'm trying to create a button that, when clicked, selects the most recent 6 months.&nbsp; I think I can do Select a Field and then create Toggles after that, but that won't dynamically change the date range as the months go by.&nbsp; I've been trying to use the MonthYear field with data points like Aug-2013, Sept-2013, etc.&nbsp; Any help would be amazing.&nbsp; Thanks in Advance!</P><P></P><P>Bryan</P></BODY></HTML> Tue, 07 Jan 2014 17:49:28 GMT 2014-01-07T17:49:28Z Button Selecting Most Recent 6 Months https://community.qlik.com/t5/QlikView/Button-Selecting-Most-Recent-6-Months/m-p/478257#M1122221 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I'm trying to create a button that, when clicked, selects the most recent 6 months.&nbsp; I think I can do Select a Field and then create Toggles after that, but that won't dynamically change the date range as the months go by.&nbsp; I've been trying to use the MonthYear field with data points like Aug-2013, Sept-2013, etc.&nbsp; Any help would be amazing.&nbsp; Thanks in Advance!</P><P></P><P>Bryan</P></BODY></HTML> Tue, 07 Jan 2014 17:49:28 GMT https://community.qlik.com/t5/QlikView/Button-Selecting-Most-Recent-6-Months/m-p/478257#M1122221 2014-01-07T17:49:28Z Re: Button Selecting Most Recent 6 Months https://community.qlik.com/t5/QlikView/Button-Selecting-Most-Recent-6-Months/m-p/478258#M1122222 <HTML><HEAD></HEAD><BODY><P>Search String:</P><P>='&gt;' &amp; AddMonths(monthstart(max(Date)),-6)</P><P></P><P>See attached for full example.</P></BODY></HTML> Tue, 07 Jan 2014 18:09:49 GMT https://community.qlik.com/t5/QlikView/Button-Selecting-Most-Recent-6-Months/m-p/478258#M1122222 Nicole-Smith 2014-01-07T18:09:49Z Re: Button Selecting Most Recent 6 Months https://community.qlik.com/t5/QlikView/Button-Selecting-Most-Recent-6-Months/m-p/478259#M1122223 <HTML><HEAD></HEAD><BODY><P>Thanks much!&nbsp; It took me a while to implement because my Date field had a timestamp in it.&nbsp; Not sure why Qlikview would auto-populate a timestamp and then not allow you to calculate dates off of it, but the problem is solved nonetheless.&nbsp; Thank you!</P></BODY></HTML> Tue, 07 Jan 2014 20:38:58 GMT https://community.qlik.com/t5/QlikView/Button-Selecting-Most-Recent-6-Months/m-p/478259#M1122223 2014-01-07T20:38:58Z