Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What are the qlikview Components?
what are the tools used for qlikview optimization?
explain firstsortorder?
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
Thanks Siva,
Still some confusions on QlikView Components.
read somewhere qlikview components are QlikView Server, Publisher and Developer is this right?
Yes, but with respect to architecture the qlikview components are Qlikview server, publisher and developer. If you are asking generally about the qlikview components, above said subroutines will be my answer.
QlikView deployments have three main infrastructure components: QlikView Developer, QlikView Server (QVS) and QlikView Publisher.
QlikView Developer is a Windows-based desktop tool that is used by designers and developers to create 1) a data extract and transformation model and 2) to create the graphical user interface (or presentation layer).
QlikView Server (QVS) handles the communication between clients and the QlikView applications. It loads QlikView applications into memory and calculates and presents user selections in real time.
QlikView Publisher loads data from different data sources (oledb/odbc, xml, xls), reduces the QlikView application and distributes to a QVS.
Regards,
Siva