optimizing a qlikview application

[Anonymous]

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.

[kaushiknsolanki]

Hi,

Must read document for you.

Performance and Optimization Best Practices in QlikView & Qlik Sense

This should help you.

Regards,

Kaushik Solanki

[Anonymous]

can you please help in elaborating more over here,

as i need to do this urgently.

[Anonymous]

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.

[Anonymous]

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

[Siva_Sankar]

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

[vardhancse]

Hi,

can please start using document analyzer, very useful app.

Document Analyzer V3.0 Update Available

[lawrance]

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

[Muthu]

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

[Anonymous]

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