title: Qlikview button make selection
body: <p>I have a button that when it is clicked I want it to select the last 14 days. This means that if today's date is 2014-03-12, I want it to select all dates between 2013-02-26 and 2014-03-12.</p>
  
  <p>I have a <code>time_table</code> with the fields <code>KEY_timestamp (yyyy-mm-dd)</code>, <code>year</code>, <code>month</code>, <code>day</code>.</p>
  
  <p>In my button I have an action <code>Select in Field</code>, with the field <code>KEY_timestamp</code> and I have a <code>Search String</code> which looks like</p>
  
  <pre><code>=if(
      now() - 14 &lt; KEY_timestamp,
      KEY_timestamp
  )
  </code></pre>
  
  <p>Now, to tell you the truth I have no idea how to go about this, and my experience with Qlikview is limited at best... I hope somebody can point me in the right direction. I tried Googling this but I've been unsuccessful so far.</p>