1 Reply Latest reply: Oct 5, 2017 11:35 AM by Sunny Talwar RSS

    Qlik Sense Set Analysis - Retrieving when MAX/MIN occurs

    Etienne Fraisse

      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