Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
1)Pivot table, 2)range time dimension, 3)expression ,4)what i wanna achieve
Sorry for the confusion in posting pictures but it was my first discussion.
Thanks again
A sample application, implementing what you want to do is attached. Hope this gives you ideas for implementation of your application.
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
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
Revised sample application where the last interval is highlighted is attached.