Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

flemmingbj
New Contributor

Minimum value for a range

Hi

I want to find the lowest value of "Time" for a given Incident number, where "New Value" starts with "A"  and put it into a new variable in the example below. The number of rows per incident varies.

I have tried RangeMin, but can't make it work... Any suggestions?

Example:

Incident numberNew valueTime
1A00:39
1Ax00:45
2B15:16
2A15:21
3B16:05
3Ax16:06
3A16:15
3Bx16:21

Expected output:

Incident numberLowest value, A*
100:39
215:21
316:06
4 Replies
jaumecf23
Contributor III

Re: Minimum value for a range

Hi,

Try this:

Date(min({<[New value]={"A*"}>}Time),'HH:mm')

Re: Minimum value for a range

May be with this

=Min({<[New value] = {"A*"}>}Time)

flemmingbj
New Contributor

Re: Minimum value for a range

But this doesn't find the lowest value per incidentnumber but per row, so there will be multiple values per incident - one per row.

The min function should find the value within the range of uniqe incidentnumbers.

Re: Minimum value for a range

Not sure I understand, but are you having more than one dimension in your chart? I thought you only wanted Incident Number as your dimension?

Community Browser