topic Performance tuning in QlikView? in QlikView

Performance tuning in QlikView?

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

Hi Experts,

What are the techniques used for Performance Tuning in QlikView?

Thanks in Advance,

Leela Madhav

Re: Performance tuning in QlikView?

swuehl — Wed, 24 Feb 2016 22:41:30 GMT

That's a pretty general question, are you looking for script or UI performance tuning?

Trying a general answer, too:

- Identify performance bottlenecks (don't try to optimize when there is no issue)

- Analyze, identify potential alternatives

- Implement alternatives and validate that performance is increased

To add some more concrete suggestions for best practices:

*** 6 Weeks in to QV Development, 30 Million Records QV Document and Help Needed!!! ****

Re: Performance tuning in QlikView?

Chanty4u — Thu, 25 Feb 2016 04:58:57 GMT

chk dis

Re: Performance tunning Qliksense documents

Performance Tuning

Re: Performance tuning in QlikView?

Anonymous — Thu, 25 Feb 2016 05:44:43 GMT

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.

Re: Performance tuning in QlikView?

Anonymous — Thu, 25 Feb 2016 05:46:04 GMT

check this as well?

Advanced performance tuning techniques into QV.

Bardess Group: Business Analytics & Data Strategy. 973-584-9100

Performance | Qlikview Cookbook

Re: Performance tuning in QlikView?

Anonymous — Thu, 25 Feb 2016 08:48:22 GMT

Thanks for information

Regards

Leela Madhav