topic Re: About optimisation techniques in QlikView

About optimisation techniques

Thu, 19 Feb 2015 07:00:12 GMT

Can any one please explain optimisation techniques for creating a dashboard?

Re: About optimisation techniques

its_anandrjs — Thu, 19 Feb 2015 07:44:54 GMT

Hi,

For Dashboard optimization you can follow some steps

1. Create the SET expressions.

2. Do not use If conditions in the expression part.

3. Use only useful fields and rest to be deleted.

4. Same for table not use all tables use only business tables.

5. Try to use Mapping load.

6. Make a star schema for data model.

Regards

Anand

Re: About optimisation techniques

AbhijitBansode — Thu, 19 Feb 2015 07:48:08 GMT

Hi, there are lot of posts available around this topic:

listed few of them.

http://community.qlik.com/message/668986#668986

http://community.qlik.com/message/654682#654682

http://community.qlik.com/message/438756#438756

Symbol Tables and Bit-Stuffed Pointers

Re: About optimisation techniques

mukesh24 — Thu, 19 Feb 2015 09:45:41 GMT

Hi Ramana,

Optimization done at Backend(Scripting side) & also GUI perspective. First Optimize u r model then came on GUI.

Regards,

Mukesh Chaudhari.

Re: About optimisation techniques

Anonymous — Thu, 19 Feb 2015 10:25:55 GMT

Hi Ramana,

Optimization can be done at three levels:

Server Level

Data Compression Technique

Breaking single large QVW file into multiple smaller QVW

Load Balancer

Scripting level

Removing Synthetic key

Dropping Temporary Tables

Handling Expressions/Calculations

Use of Auto number Function

Design level.

Monitoring Memory Consumption at Object Level

Minimized Chart Vs Maximized Chart

Check http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

http://community.qlik.com/docs/DOC-3732

optimize and non-optimze load in qvd

diffrence b/w optimized load and unoptimized load

Regards

Neetha

Re: About optimisation techniques

Thu, 19 Feb 2015 15:59:16 GMT

Thanks Neeta,

This would be very helpful...

Re: About optimisation techniques

Anonymous — Thu, 19 Feb 2015 17:02:36 GMT

please close the thread,if you are happy