Button Selecting Most Recent 6 Months

[#1]

Hello All,

I'm trying to create a button that, when clicked, selects the most recent 6 months.  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.  I've been trying to use the MonthYear field with data points like Aug-2013, Sept-2013, etc.  Any help would be amazing.  Thanks in Advance!

Bryan

[Nicole-Smith · Accepted solution]

Search String:

='>' & AddMonths(monthstart(max(Date)),-6)

See attached for full example.

[#3]

Thanks much!  It took me a while to implement because my Date field had a timestamp in it.  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.  Thank you!