topic Re: Find max value of a range time in QlikView

Find max value of a range time

Sat, 12 Jan 2013 21:13:30 GMT

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

Sat, 12 Jan 2013 21:19:31 GMT

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

Re: Find max value of a range time

Sat, 12 Jan 2013 21:21:38 GMT

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

Thanks again

Re: Find max value of a range time

nagaiank — Sat, 12 Jan 2013 23:49:18 GMT

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

Sun, 13 Jan 2013 09:13:20 GMT

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

SunilChauhan — Sun, 13 Jan 2013 09:25:51 GMT

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

nagaiank — Sun, 13 Jan 2013 10:18:08 GMT

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