title: Set Analysis in QlikView Current Vs Last Month
body: <p>I am trying to show Current Month Stats in a column and Last month stats in another column. While using Set Analysis I am facing issue that I can not get numbers for Last month</p>
  
  <p>This is the statement I am using but it does not work: </p>
  
  <pre><code>/*Statement For Last Month*/
  Sum( {$&lt;CalMonthYear={"=$(=Max(CalMonthYear)-1)"}&gt;} [DSP-Subscriber_Count])
  /*Output here is the Sum of All Months */
  </code></pre>
  
  <p>Ideally it should give me the same output as following statement does</p>
  
  <pre><code>/***Last Month Hard Coded Script****/
  Sum( {$&lt;CalMonthYear={'Feb 2015'}&gt;} [DSP-Subscriber_Count])
  </code></pre>
  
  <p>I have tried several variations but none seem to work. Any ideas as to what I might be doing wrong.</p>
  
  <p>Thanks</p>