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
-
QlikView provides a feature called Autogenerate which use for generate data using system’s programming. Using Autogenerate, QlikVie...
-
Keep: it will not join two tables and they will be stored in QlikView as two separate named tables. Keep will always preceded by one of th...
-
Optimized load is much faster and therefore preferable, especially for larger data sets. Optimized loads are possible if no transformations...
-
Boxplot The boxplot becomes interesting for statistical applications. Over a dimension, it calculates the expression and finds the di... -
To connect a QlikView server (QVS) each client needs a CAL (client access license) The CAL’s are purchased with QlikView Server and tied t...
-
No Concatenation: if the two tables have same fields also No Concatenate treats as separate internal tables
-
ODBC, OLEDB, SAP connectors
-
1st Tier - Raw data is getting loaded and QVD is creating. 2nd Tier - QVD is transform in the business login and requirement of the bus...
-
Set: this command assigns the variable the text to the right of equal sign. Let: assigns the variable whereas Let command evaluates...
-
Information density of the field, which indicates the percentage of rows that contain a non-null value Subset ratio, which shows the ...
0 Comment to "How do you optimize QlikView Application?"
Post a Comment