For Optimization we can optimized the QVD which is used in the QVW files in the backend. For QVW optimization I believe not use any tools we can manually remove unwanted fields form data model or comment it, remove most complex logics from the load script or create it with the simple way because it will take long time for loading. If using large data base file try to create the incremental load for the QVD or load latest data only.
Wednesday, 26 August 2015
Subscribe to:
Post Comments (Atom)
Weekly
-
Star Schema: In a star schema, the fact table will be at center and in connected to dimensional tables. The tables are completely in De...
-
What are the multiple protocols defined for client communication with QVS? Explain different communication encryptions for Windows Client...
-
What are the important features of Qlik Sense? Drag-and-drop visualizations Scalability and Manageability Powerful Open and Standard A...
-
We can load data from ODBC, OLEDB, SAP connectors by connect, select statements and also we can load flat files like excel, word, xml etc… ...
-
Returns a set of values of expression calculated over dimension Ex: Aggr(sum(sales), country)
-
What is the use of Cross table prefix in QlikView Load Script? What is the difference between Map Using and Mapping Load? Synthetic Keys ...
-
Boxplot The boxplot becomes interesting for statistical applications. Over a dimension, it calculates the expression and finds the di... -
For Optimization we can optimized the QVD which is used in the QVW files in the backend. For QVW optimization I believe not use any tools w...
-
RDBMS: stands for Relational Database Management System. It organizes data into related rows and columns. It stores data in Tables havin...
-
Explain Aggr Function? What is the use of First Sort Value in QlikView? What are Set Modifiers and Set Identifiers? What is P() ...
0 Comment to "How do you optimize QlikView Application?"
Post a Comment