Help on firstsorted value

[ashishbhuyekar]

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.

[sunny_talwar]

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