Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one please explain optimisation techniques for creating a dashboard?
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
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
Hi Ramana,
Optimization done at Backend(Scripting side) & also GUI perspective. First Optimize u r model then came on GUI.
Regards,
Mukesh Chaudhari.
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
Dropping Temporary Tables
Handling Expressions/Calculations
Use of Auto number Function
Design level.
Monitoring Memory Consumption at Object Level
Minimized Chart Vs Maximized Chart
optimize and non-optimze load in qvd
diffrence b/w optimized load and unoptimized load
Thanks Neeta,
This would be very helpful...
please close the thread,if you are happy