Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi..
what is the performance tuning in qlikview... Tell me some better ways how to performance tuning in qlikview
thank you
Hi,
Please go through this links:
Improving Qlikview Load Performance
QlikView Performance Monitoring
Hope it will help!!
Hi,
Please go through this links:
Improving Qlikview Load Performance
QlikView Performance Monitoring
Hope it will help!!
Hi,
Performance tuning means simply reducing the loading time of the charts and Dashboard loading time. Performance tuning in Qlikview is done at various stages, ie.,in front end and backend of the qlikview application.
Backend:
Do all the required calculations in the script itself.
Load only required data, for example if you are using only last 5 years data filter it out when you are loading data.
Load only required columns and tables so that Qlikview file size would be reduced.
If you are loading same tables in multiple dashboards then for the instance load from database and store it in QVDs and in other Dashboards load from QVD.
Frontend:
Use Set Analysis as much as possible.
Don't display all charts in a single sheet or provide buttons to show and hide the charts.
Don't display huge data in Tables, restrict user to do some selections so that the data would be reduced and load the table faster.
Limit the calculations in front end and move it to scripting.
Hope it helps!!
Please have a look:
Thank you
qlikview novice
Its my pleasure!!
Can you tell me brief note about applymap () , lookup() and precceding load
Thannk you
Hi,
Mapping Load: The mapping prefix is used on a load or select statement to create a mapping table, these tables are different from other tables. They will be stored in separate area of memory and used as mapping tables during script execution. After execution they will automatically drop.
Ex. Mapping (Load Statement/Select Statement)
Apply Map: used for mapping data from one source to another at load time.
Ex. Apply map (‘Mapname’, expr,[default expr])
applymap: it is used to add the fields to our table with the help of other table . It is used as joins. The main diff between join and apply map is : If we have to add multiple fields i prefer join if we have to add one or two fields I prefer apply map
Mapping: The mapping prefix is used to create a mapping table that can be used for e.g. replacing field values and field names during the script run.
Preceding Load:
The preceding LOAD feature allows you to load a table in one pass, but still define several
successive transformations. Basically, it is a LOAD statement that loads from the LOAD or SELECT
statement below, without specifying a source qualifier such as From or Resident that you would
normally do.
You can stack any number of LOAD statements this way. The statement at the bottom will be
evaluated first, then the statement above, and so on until the top statement has been evaluated. You
can achieve the same result using Resident, but in most cases a preceding LOAD will be faster.
Another advantage of preceding load is that you can keep a calculation in one place, and reuse it
in LOAD statements placed above.
Lookup:
lookup(fieldname, matchfieldname, matchfieldvalue [, tablename])
Returns the value of fieldname corresponding to the first occurrence of the value matchfieldvalue in the field matchfieldname.
Fieldname, matchfieldname and tablename must be given as strings (e.g. quoted literals).
The search order is load order unless the table is the result of complex operations such as joins, in which case the order is not well defined.
Both fieldname and matchfieldname must be fields in the same table, specified by tablename. If tablename is omitted the current table is assumed.
If no match is found, null is returned.
Hope it will help!!
Hi Krishna,
If you got the answer please mark either helpful or correct and close the discussion.
Thank You