10 Replies Latest reply: Apr 27, 2010 7:01 AM by MBharambe RSS

    Getting Min values for the remaining dataset

      Hi,

       

      Have a small problem, I need to calculate the minimum values of the dataset corresponding to the value as of today. Let me explain with an example

       

      DateValueMin Value
      1101
      2110105
      3105
      4109
      5115109
      6117109
      7109
      8120111
      9111
      10130

       

       

       

      On Day 1 the value is 101 and there is no value lesser than 101, so min value is blank.

      On Day 2 the value is 110 and for the remaining period the min value is 105, so selected Min Value is 105

      On Day 3 the value is 105 and for the remaining period the min value is 105, so Min Value is blank

      Similarly on Day 5 the value is 115 and for the remaining period the min value is 109, so selected Min Value is 109

       

      How to get such values in QV?