3 Replies Latest reply: Feb 24, 2015 5:11 AM by Manish Kachhia RSS

    How to calculate the Maximum price on basis of current selection of a date to previous 52 weeks



      I have a requirement as follows:


      When I select a date, i want to calculate the maximum price from that selected date to previous 52 weeks .


      Date               Price

      12/12/2013     500

      12/12/2014      200

      11/11/2014      400


      when I select the date as 11/11/2014 I should consider from 11/11/2014 to 52 weeks prior to that and fetch the maximum value.in this case I should get result as 500.


      similarly when I select a diff date,it should change dynamically.


      How do I accomplish this in qv?