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

# 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

• ###### Re: Find max value of a range time

1)Pivot table, 2)range time dimension, 3)expression ,4)what i wanna achieve

• ###### Re: Find max value of a range time

Sorry for the confusion in posting pictures but it was my first discussion.

Thanks again

• ###### Re: Find max value of a range time

A sample application, implementing what you want to do is attached. Hope this gives you ideas for implementation of your application.

• ###### Re: Find max value of a range time

Hi krishnamoorthy,

thank you a lot for the answer, the point is that (using your example) I was able to show the range of minute but i would like to visualize just the with the 'max/highest range of minute', in your example  i would like to show for aufgabe-date just the last record in yellow

Thanks again

• ###### Re: Find max value of a range time

i thing you need to do below

Create one variable

In Dimension

Aufgabe ,date

In Expression:

1)Max(Each of 5 time) ----> go to Number and tick Timestamp

2)Val

hope this helps

• ###### Re: Find max value of a range time

Revised sample application where the last interval is highlighted is attached.