Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qlik Sense Set Analysis - Retrieving when MAX/MIN occurs

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

1 Solution

Accepted Solutions

Re: Qlik Sense Set Analysis - Retrieving when MAX/MIN occurs

How about this

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

1 Reply

Re: Qlik Sense Set Analysis - Retrieving when MAX/MIN occurs

How about this

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

Community Browser