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/][img]http://farm7.static.flickr.com/6093/6321689485_3d46897a3c.jpg[/img][/url]
      [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.

      Regards
      Mark