Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Optimize response time report

How to optimize time response for report in server within qlikview ?

Any recommendation ?

2 Replies
kuczynska
Creator III
Creator III

Hi there,

Can you please be more specific regarding your expectations and issues you are experiencing right now? Are you asking about the reload time itself or the response time from the report in Access Point?

In general there are few things we all should remember when creating any model in QV - using numeric key fields instead of text, trying to optimize the data model (using the power of optimized QVD load), don't load more than you should, drop unused/temp fields, try to move the most complex calculations to the load script. Try not to overuse calculated dimensions and if possible - replace some of your more complex expressions with variables for example.

Big front end objects (something like download straight/pivot tables) will require more time to calculate, each time you are actually making a selections. If your data set is big, try to use more drill-down groups as your dimensions, trigger bookmarks with some selections at the document opening or force some of the listboxes to always have one value selected. This will force the end user to interact with your application and will stop QV from bringing entire data from the beginning. At the end of a day - this will improve the response time. Maybe the above will be of any help to you.

Anonymous
Not applicable
Author

hi jaweher,

please see below post

Re: Qlikview features