Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
FirstSortedValue in your case will give you the Total1 associated with the minimum value of Path (based on your dimension)