Firt value of a selected range of date

[jorditorras]

Dear Gurus,

I have a table like:

Date-Time	R Factor
4 October 18:38:01	20
4 October 18:37:01	12
4 October 18:36:01	45
4 October 18:35:01	52
4 October 18:34:01	21
4 October 18:33:01	34
4 October 18:32:01	53
4 October 18:31:01	35
4 October 18:30:01	45
4 October 18:29:01	33
4 October 18:28:01	25
4 October 18:27:01	37

where Date-time is the Range of Date that I have selected. I would like have a KPI that shows the first value of the selected range of Date. That woud be:

R Factor = 37

How can I reach it?

Thanks in advance!!

Regards,

Jordi

[Anonymous]

which object you want to use?

to get the value I would use this expression

only({<[Date-Time]={'$(=min([Date-Time])'}>}[R Factor])

[Chanty4u · Accepted solution]

try

=firstsortedvalue(Rfactor,-DateTime)

or

=firstsortedvalue(Rfactor,DateTime)

Edited: FirstSortedValue - script function ‒ QlikView

[tresesco]

=firstsortedvalue( Rfactor, DateTime)

[Chanty4u]

my bad Thanks for correction

[jonathandienst]

Do you have separate Date and Time fields? How is the user selecting a "Range of Date"?

It may be a simple as

     =Min([Date-Time])

     and

     =FirstSortedValue([R Factor], [Date-Time])