Help on firstsorted value

ashishbhuyekar — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am working on qlikview dashboard where i can see below expression is used where FirstSortedValue ( {< ID,Total1 Used, can anyone help me to understand what exactly firstsorted fuction with field1,field2 will do?

if(len(vSelect)=0 ,sum({<ID,Total1 = {"$(=max(Total1))"}>}Total1),FirstSortedValue ( {< ID,Total1 = {">=$(vSelect)"} >}Total1,Path))

Thanks in advance.

Re: Help on firstsorted value

sunny_talwar — Tue, 19 Jun 2018 14:52:32 GMT

FirstSortedValue in your case will give you the Total1 associated with the minimum value of Path (based on your dimension)

topic Help on firstsorted value in QlikView

Help on firstsorted value

Re: Help on firstsorted value