Discussion board where members can get started with QlikView.
I want to show the equipment name with the longest interval in a KPI.
My data looks like this:
and so on.
I have counted the duration in minutes for each entry. I simply used =interval(end-start,'m'). Then I take the maximum of those with max().
Now in the KPI widget I want to show the name of the elevator with the longest interval time. How would I do that?
View solution in original post
Thank you Sergio! This worked. It was more simple than I thought.
What about if I want the Equipment with the highest average interval (per equipment)?
EDIT: Managed to solve myself with