Last value loaded

[jorditorras]

Dear Gurús,

I have loaded a table in QlikSense like this:

Date-Time	Tension Ref.
07 Aug 15:55:01	845
07 Aug 15:54:03	836
07 Aug 15:53:05	565
...	...
05 Aug 16:04:02	546
05 Aug 16:03:05	768
05 Aug 16:02:04	645

I want to create a Straight Table in a QlikSense Dashboard with the last "Tension Ref" loaded. I want to obtain the result 845.

I have tried several ways but I can't achieve it. Can anyone help me, please?

Thanks!!!

Regards,

Jordi

[sunny_talwar · Accepted solution]

May be this

FirstSortedValue(DISTINCT [Tension Ref], -[Date-Time])

Where Date-Time is read as date field by Qlik Sense

[its_anandrjs]

This is working what error you get paste this expression in any text object that gives you 845.

=FirstSortedValue(distinct [Tension Ref.],-Date_Time)

[jorditorras]

Yes, I already corrected my answer and marked Sunny's solution as "Correct".

Thanks for your message.

Regards,

Jordi