6 Replies Latest reply: Jan 13, 2013 5:18 AM by Nagaian Krishnamoorthy RSS

    Find max value of a range time

      Hi All,

       

      I´m new in the community and to Qlikview and actually I have a problem for which i would appreciate an help.

       

      In my company they have asked me to create a pivot table in order to control the activity of some working station in a range of time, being precise in last 5 min.

       

      Till now ihave created the pivot that has as dimensions:

       

      • Working station
      • Date
      • Range of time

       

       

      Here the formula to set the range time

       

       

      and the formula for the expression

       

       

      Actually my problem is that, for ech day I wanna just show the last 5 minutes of activities and not the entire activity during the day divide by 5 min.

       

      So in my pivot i would like to show just the MAX value of the time range, as show here below for this day jst the record in yellow

       

       

      Can someone help me how can I do it?

       

      Thanks a lot in advance to everyone.

       

      Ciao