FirstSortedValue()

[#1]

Hi all,

i am new to qlikview just want to know that

how  FirstSortedValue() works in Qlikview... Can any one ive me a example ?

Load Customer,

firstsortedvalue(PurchasedArticle, OrderDate) as FirstProductBought from abc.csv

group by Customer;

???? i am unable to understand this through help also

Message was edited by: rohitkoul

[prasadmundewadi]

What happens if there are null values in the data. are those going to come first or those go to the end.

E.g.

FieldA, FieldB

A, 3

B, 4

C,               //note FieldB has null for C

D, 2

[sonysree88]

We can able to suppress the nulls as per the  measure filed

[ramcena306]

Hi Prasad,

In that  case , if C= Null, then it returns D value. i,e. 2