Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New Contributor III

Help on firstsorted value

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.

1 Reply

Re: Help on firstsorted value

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