Optimize Qlikview Document

qlikview
optimization

#1

Hi,

I have developed a dashboard in Qlikview, It has 2 transaction tables and 3 master tables. Processing of this Qlikview document is not good. Can you suggest me the way to optimize Qlikview document.

Regards,
Satish


#2

@Satish
It can be done in Qlikview at three level:

  1. Server
  2. Scripting
  3. Design

At Server level, you can perform this using load balancer, Breaking large QVW file into smaller ones and using more data compressing techniques.

At Script level, You can drop synthetics keys, drop temporary tables (Not used), Optimizing complex expressions. Heavy expressions or calculations greatly hinder the performance.

At Design Level, Monitoring memory consumption at script level, Use auto minimized chart. it consumes less memory compare to maximize one.

Hope this helps…

Regards,
Sunil