Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
New Contributor III

Performance Improve

HI All,

Please help me out to how to improve the performance of any application?

What best practices I have to follow to improve the performance?

Thanks,

Sagar

SGP
4 Replies
Highlighted
Luminary
Luminary

Re: Performance Improve

Hi,

this is too general. Can you be more specific, what challenges are you facing? rwunderlich‌ keeps a nice blog http://qlikviewcookbook.com, where you can find many tips, tricks and tools to help you with app performance.

Juraj

Highlighted
New Contributor III

Re: Performance Improve

Hi Juraj,

Actually I have to check pre developed application and I need to identify the key objects to improve performance of that application.

Thanks,

Sagar

SGP
Highlighted
Luminary
Luminary

Re: Performance Improve

In general, you can check for:

- complex calculations, for example with nested If() statements or calculated dimensions

- complex usage of set analysis

- complex data model with many tables and long path from one side to other (especially if you combine fields from many different tables in Qlik objects)

- long text fields

- fields with high cardinality, i.e. too detailed fields (timestamps, calculated fields with many decimal places)

- unnecessarry fields in general

- complex string keys -> ideally convert them to numeric using Autonumber()

You can use Rob's Document Analyzer tool to get ideas and suggestions for improvement, you'll find it on his page I posted before.

Highlighted
Partner
Partner

Re: Performance Improve