8 Replies Latest reply: Nov 7, 2011 8:09 AM by Joseph Simmons RSS

    Set Analysis help required

    Mark Sheraton

      See the attached qvw and the following diagram for more detail.


      [url=http://www.flickr.com/photos/angrybunny/6321689485/]Untitled[/url] by [url=http://www.flickr.com/people/angrybunny/]AnAngryBunny[/url], on Flickr



      The minimum date (vMinDate) for all data is 01-Oct-2010.
      The user selects the date range (Nov '11).

      I want to sum QTY (imp) delivered from the minimum date (01-Oct-2010) to the maximum user selected date (31-Nov-11)
      I've done this with this statement.



      sum({$<Date={">=$(vMinDate)<=$(=max(Date))"}>} Imp)

      But I also want to exclude expired Ad's, where the an end date is less than the minimum user selected date (01-Nov-11).
      I don't know how to do this with Set Analysis, please help.