title: Current Month Without Using Selection - QlikView Set Analysis
body: <p>I am stuck with some mysterious issue while trying to get Revenue for Current Month.
  My Limitation is Simple :</p>
  
  <p><strong><em>I need Current Month Revenue Without Having to do any selections.</em></strong></p>
  
  <p>So here are the details :
  <strong>Data_Date</strong> field has two values one for Dec, and one for Nov 2016</p>
  
  <pre><code>     11/15/2016
       12/15/2016
  </code></pre>
  
  <p>I have declared a variable <strong>vCurrent_Month</strong></p>
  
  <pre><code>  =Date#( Max(Data_Date))
  </code></pre>
  
  <p>Value in Variable is correctly Reflecting <strong>12/15/2016</strong></p>
  
  <p>Given below is my Set Analysis Expression used in Text Object:</p>
  
  <pre><code>  =Sum({1&lt;Date#(Data_Date)={"(vCurrent_Month)"}&gt;}TOTAL_REVENUE)
  </code></pre>
  
  <p>I am getting following error </p>
  
  <pre><code>  Error: Error in set modifier expression
  </code></pre>
  
  <p>I have been stuck for hours and I have tried several tutorials and ways to get the same result but there seems to be no way out. Any help is highly appreciated.
  Thanks</p>