i am new to qlikview just want to know that
how FirstSortedValue() works in Qlikview... Can any one ive me a example ?
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
Imagine you have the following table:
If you run a FirstSortedValue(FieldA, FieldB) you'll get the first sorted value from FieldA based on the sorting of FieldB. Value 1 is the first value for FieldB so the function will in this example return C.
if if(FirstSortedValue( likes ,-record_date,8)<>'',FirstSortedValue( likes ,-record_date)-FirstSortedValue( likes ,-record_date,2))
now what about this numeric value?
I woud like to get the last value for each customer.
If i use the firstSortedValue function, it return the first value but i need to get the last purchase for each customer.
I want the output table look like this
I guess in your case only group by function will solve your purpose...to get desired out put...
(ooxml, embedded labels, table is [group by]);
max (date (orderdate))
Group by customer;
DROP Table old;