Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
We can able to suppress the nulls as per the measure filed
Hi Prasad,
In that case , if C= Null, then it returns D value. i,e. 2