Qlik Sense Set Analysis - Retrieving when MAX/MIN occurs

[#1]

Hi,

I'm trying to retrieve in a KPI when the min or max value of my dataset occurs.

To put it simply I got 2 fields, one with times stamps and another with values. I want to retrieve the timestamp of the min/max value in a set expression.

I tried sum({<Value={$(=Max(Value))}>} [Date/Time]), it returns an absurd result,

I tried a simple if(Value=max(Value),[Date/Time]) and returns nothing.

Probably simple but I couldn't find any clue here yet and any help would be much welcome!

Etienne

[sunny_talwar · Accepted solution]

How about this

FirstSortedValue(DISTINCT [Date/Time], -Value)