Display 'First value of expression in chart' in textbox

[Athira_K]

Hello,
I have a chart with few expressions
How can I bring the first,last and last before value of that expression column?
Is there any function that can help?
Thank you

[anat]

have u tried using firstsortedvalue

[Athira_K]

Hi,
I tried it,but its giving the sorted first value and its giving error using this expression:
=FirstSortedValue(If(F=0,Interval(Max(FinalTime)-InitialTime,'hh:mm:ss.fff')))

[anat]

give a try using Max function.

Max - chart function ‒ Qlik Sense on Windows

[Athira_K]

 Hi

Max function is returning the maximum value and also it shows nested aggregation not allowed

 https://community.qlik.com/t5/QlikView-App-Dev/Nested-Error/m-p/1896448#M1217560