If you are working with QlikView, these tips will interest you

[seonajmulislam00]

A while ago, one of Data IQ 's consultants set out to reveal the small tips that can make a big difference when it comes to improving performance and resource usage while we are working on developing a QlikView application .

And he did very well!

For this reason, here are some of the Quick Tips that Agustín Leira worked on , which you can find in full at the end of the article.

1) Using Task Manager
It should be used as an additional tool when developing and testing applications made in Qlikview . It is used to know how much the processor(s) of our computer are working while we use the application.

In case of having one or more processors, if one armenia phone number lead processor is being used almost at 100% and the rest at a low percentage, this means that we have only one thread of execution in our application to perform all the calculations of the selections made.

How do we reduce processor usage?QlikView Tips

2) How can we improve the performance of the application when using a count (Distinct <fieldName>)?
Every time we make a selection in the application, three phases are triggered:

1. Filter the data from the selection made (multiple threads);

2. It is responsible for bringing the design of the selected objects (only one thread);

3. Perform the calculation for each of the selected objects (multiple threads).

The count(Distinct <fieldName>) expression is processed on a single thread and that is good for application performance, but the fields used by this function are often in different tables in the data model, so the complexity of the expression increases.

The solution is to shorten the distance used by the fields in the expressions and dimensions. If the fields are in the same table or in nearby tables, the calculation of the expression will be faster.

3) The Data Model: What should we take into account when designing it?
The speed of the application so that the user can navigate fluently;
Have few Fact Tables to perform the calculation of the expressions, given that these consume many resources;
Avoid synthetic keys and circular references;
Do not go through several tables to relate fields. We must try to make the fields to be related as close as possible:
ExampleQlikView Tips

4) Isolation Techniques
To determine if the application's performance issues are in the Data Model or in the User Interface , we can load the application binary and put it into a new .qvw file. This way we will know if the objects perform better in the newly created file than in our application.