topic Process Improvement in QlikView

Process Improvement

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

Can anyone suggest that, what can I propose as a Process Improvement for my Qlikview Application ?

Re: Process Improvement

adityaakshaya — Mon, 09 Apr 2018 18:19:14 GMT

Hi Mansi,

I don't know what approach you have taken while developing your application but you can refer to attached document which talks about optimization. This can help you to decide what process improvement you need to implement in your Qlikview Application.

Re: Process Improvement

Anil_Babu_Samineni — Tue, 10 Apr 2018 01:40:23 GMT

What process you want to improve? Can u describe little

Re: Process Improvement

Siva_Sankar — Tue, 10 Apr 2018 01:45:42 GMT

Hi Mansi,

Here is the Qlik blog with documents on How To Improve Your Design Process Working With Qlikview

If you are looking for performance improvement then this thread will help improving QlikView performance

-Siva

Re: Process Improvement

Nagaraju_KCS — Tue, 10 Apr 2018 04:19:31 GMT

Hi Mansi,

Optimizations

Script Level:

* Avoid the synthetic keys. Remove unnecessary links and joins tables explicitly in the script.

* If a reloads takes a great deal of time, use a binary load of static historical data.

* Drop tables from memory in the script once they have fulfilled their role.

* Use the AutoNumber() function to create a compact memory representation when using a complex composite key.

UI Level (layout):

* The memory used by objects and calculation times can be maintained in the sheets tab of the document properties. A good way to find bottlenecks in the application.

* Minimized charts do not take up memory. Uses the auto minimize option with charts that do not need be displayed at the same time.

* Force the user to make a selection before a large chart is displayed to reduce chart calculation times.

* Use appropriate messages while charts are being calculated.

* Avoid long expression with multiple string comparisons.

* Avoiding showing frequencies in Listboxes where not necessary.

Regards,

Raju