Last record

[JoseGarcia]

Hi there, 

I'd like to show in a numerical KPI the value of last record submitted.

using formula: 

aggr(max(Quality_score), Quality_score)

but this is not returning any values at all.

Any ideas?

Thanks 

[Or]

FirstSortedValue() should do the trick

[JoseGarcia]

LastSortedValue(Quality_score)

?

[Or]

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/Aggrega...

Sorry, you caught my post pre-edit.

Parameters should be the value and the sort weight. Value is the field you've been using and sort weight would presumably be the record's timestamp.

[nehakakar]

Try this..

aggr(max({<DateField>} Quality_score), DateField)

for more detail Official Doc 

[JoseGarcia]

@nehakakar 
formula did not work, I think this because my Date field 'Created' is not seen as a date