Home > Software > QlikView
Interview Questions   Tutorials   Discussions   Programs   Videos   

QlikView - How do you optimize QV Application?




1649
views
asked SRVMTrainings November 18, 2014 11:41 PM  

How do you optimize QV Application?


           

2 Answers


-1

 
answered By rgv   0  

Qlikview application can be optimized by created the data into qvd’s .when whole qvw application is changed to qvd .this qvd will be stored in the ram . We use synthetic keys,circular references etc to optimize the qlikview application.

flag   
   add comment

 
answered By SRVMTrainings   0  
Merge tables to reduce joins at run time, create flatter structure at load time.

Optimize QV in UI/Application level
a) Try to avoid no of macros
b) Try to implement or use all complex calculation in script level not in UI
c)Avoid same charts in different tabs

Optimization in script level
a) Avoid synthetic keys and circular loops
b)use QVD’s
c)try to use star schema instead of snowflake schema
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  3 people following this tag

  Question tags

qlikview × 1

Asked 3 years and 6 months ago ago
Number of Views -1649
Number of Answers -2
Last updated
3 years and 27 days ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert