QlikView Scripting 9: Geliştiriciler İçin İpuçları

• One of the most important design considerations is consistency. It allows users to learn how to navigate the application faster, be more efficient, and focus more on the data rather than the interface. Once consistency has been established, users can readily transfer that knowledge of application navigation and data interpretation to other applications and contexts.
• Maintain consistent color in sheets and chart objects.
• Use the same font colors and sizes in similar areas of the application.
• In charts, keep the title bar in the same format and look, and keep the legend or axis title in the same area on all charts, if possible.
• Avoid crowded objects and charts. Some UI experts suggest no more than 6 to 8 charts for a QlikView desktop application (per sheet).
• Don't use red and green on the same chart or sheet, to avoid the red-green color blindness issue.
• Avoid using too many colors, and avoid randomly assigned colors. Colors should have meaning. Use the Persistent Colors feature in the chart's Colors tab, in the Chart Properties dialog.
• Use line charts or bar charts for comparing a dimension over time, and use stacked bar charts and pie charts for comparing parts to a whole.
• Some experts advise not to use more than 10 sheets in your QlikView application.
• When the charts are finished or you have a draft version, uncheck Allow Move/Size in the Layout tab of the Chart Properties dialog to limit inadvertent movement of charts in the application.
• The use of macros in a QlikView application can slow down performance.
• Note that all visible charts and objects on a graph take up RAM for the active sheet, and even objects not visible take up some amount of RAM.
• Limit the number of records displayed in a table by imposing a calculation condition, if possible.
• Use charts instead of text objects when you want to display the result of complex expression calculations.
• The date(Now) function requires much more calculation overhead (it calculates every second of the day) than the data function today(). Use today() if you need to calculate the current date.
• Reduce the number of fields in memory by limiting use of SQL select all (*) in scripts. Choose the fields you need rather than all of them. Also, drop tables in the script when they are not needed.