topic KPI with highest expression value in QlikView

KPI with highest expression value

anseglko — Sat, 16 Nov 2024 20:27:14 GMT

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?

sergio0592 — Mon, 15 Jul 2019 09:10:06 GMT

Hi,

Try with

=FirstSortedValue(Equipment,-Interval(End-Start))

anseglko — Mon, 15 Jul 2019 09:35:28 GMT

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

=FirstSortedValue(equipment,-aggr(avg(Interval(end-start)),equipment))