topic Re: Display 'First value of expression in chart' in textbox in QlikView

Display 'First value of expression in chart' in textbox

Athira_K — Thu, 24 Feb 2022 08:37:52 GMT

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

Re: Display 'First value of expression in chart' in textbox

anat — Thu, 24 Feb 2022 09:15:31 GMT

have u tried using firstsortedvalue

Re: Display 'First value of expression in chart' in textbox

Athira_K — Thu, 24 Feb 2022 09:19:44 GMT

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')))

Re: Display 'First value of expression in chart' in textbox

anat — Thu, 24 Feb 2022 09:19:20 GMT

give a try using Max function.

Max - chart function ‒ Qlik Sense on Windows

Re: Display 'First value of expression in chart' in textbox

Athira_K — Fri, 25 Feb 2022 02:28:25 GMT

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