Hi,
Find the answers below.
Qlikview Components :
Qlikview Components is a set of Qlikview scripting subroutines.
The mission of Qlikview Components is:
•Implement scripting best practices encapsulated by a simple and stable API.
•Improve the speed and quality of script development.
•Create common ground between script developers.
QVC aims to serve the needs of the "big middle" of script tasks. Not the simple tasks, not the very complex tasks, but the garden variety common needs found in many scripts.
Tools used for qlikview optimization:
Qlikview optimizer
Firstortedvalue:
firstsortedvalue([{set_expression}][ distinct ] [ total [<fld {, fld}>]] expression [, sort_weight [, n]])
returns the first value of expression sorted by corresponding sort-weight when expression is iterated over the chart dimension(s). Sort-weight should return a numeric value where the lowest value will render the corresponding value of expression to be sorted first. By preceding the sort-value expression with a minus sign, the function will return the last value instead. If more than one value of expression share the same lowest sort-order, the function will return null. By stating an n larger than 1, you will get the nth value in order.
Examples:
firstsortedvalue ( PurchasedArticle, OrderDate )
Refer:http://community.qlik.com/thread/30532
Regards.
Siva
.png "Luminary Alumni"){kind=icon}