topic Re: optimizing a qlikview application in QlikView

optimizing a qlikview application

Anonymous — Tue, 11 Apr 2017 11:19:54 GMT

i have an application size of 4 gb,it takes lot of time to open this app and also loading any of the tabs and data in the application,want to optimize

what are the steps and how to start with.

Re: optimizing a qlikview application

kaushiknsolanki — Tue, 11 Apr 2017 11:31:02 GMT

Hi,

Must read document for you.

Performance and Optimization Best Practices in QlikView & Qlik Sense

This should help you.

Regards,

Kaushik Solanki

Re: optimizing a qlikview application

Anonymous — Tue, 11 Apr 2017 14:41:38 GMT

can you please help in elaborating more over here,

as i need to do this urgently.

Re: optimizing a qlikview application

Anonymous — Tue, 11 Apr 2017 14:51:25 GMT

I have done some optimization on my qlikview application like that :

- avoid "if" and aggr in your expressions : do all possible aggregation in your script . With flag or expression directly

-If you have list selection or check box : choose always one selected value

-if you can don't use condition for dimension or calculated dimension

Hope that it helps you.

Re: optimizing a qlikview application

Anonymous — Wed, 12 Apr 2017 02:57:03 GMT

when i see the expressions used on chart that are not too complex,

i dont think so that will help

if i need to comment the unused fileds or part the applications into two,how i shud proceed as it involves lot of manual work to identify all variables ,fields,

kindly suggest

Re: optimizing a qlikview application

Siva_Sankar — Wed, 12 Apr 2017 03:09:08 GMT

Yes, it is painful to identify the unused fields from the application. Thats why Rob created an application which is very useful for performance tuning. It will help you in identifying the unused fields also suggestions to improve performance..

Document Analyzer V2 -- a major update

Re: optimizing a qlikview application

vardhancse — Wed, 12 Apr 2017 04:24:56 GMT

Hi,

can please start using document analyzer, very useful app.

Document Analyzer V3.0 Update Available

Re: optimizing a qlikview application

lawrance — Wed, 12 Apr 2017 04:48:32 GMT

Hi,

Please find the below possible solution this will may helpful.

1) Avoid Conditional Dimension

2) If you have hide/show in single sheet please use separate sheet.

3) Remove the OnOpen trigger if you have in your QVW

4) Please look into the cache memory, this will affect the load time.

Thanks,

Lawrance A

Re: optimizing a qlikview application

Muthu — Wed, 12 Apr 2017 06:13:28 GMT

Hi,

Please try the below, Hope this helps.

1. You can also separate the date fields into day month and year and join them in the dashboard.

2. Use auto number function while making keys in data model.

3. Drop the fields which is not used in the dashboard.

4. Use calculation condition for the charts.

Regards,

Muthu

Re: optimizing a qlikview application

Anonymous — Wed, 12 Apr 2017 13:48:44 GMT

my application is placed on desktop

when am trying to enter the path including the machine ,and reloading trhe applications

it says file not found

Re: optimizing a qlikview application

Siva_Sankar — Wed, 12 Apr 2017 15:47:12 GMT

Can you share a screenshot? It should work as long as the path is correct

Re: optimizing a qlikview application

vardhancse — Thu, 13 Apr 2017 03:22:12 GMT

Place both your application and document analyzer in your local path.

**Please disable "Prohibit Binary Reload".

Settings->Document properties->Opening->Prohibit Binary Reload.