Discussion Board for collaboration on QlikView Layout & Visualizations.
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
Go to Solution.
In that example it loads the instance of the PurchasedArticle based on the earliest OrderDate, i.e. the first product bought.
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?
Go through this link
Will help you learn it better.
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
You can solve by
if we write - sign before the sort-weight i.e. orderDate here, it will return the last value.
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;
I am not able to open this link. can anyone give with example.