Speeding up selection in QV

[#1]

Hi Community,

Thanks for all the help in the past.  Anyways, I was wondering if anyone had suggestions for ways I could speed up QV dashboards at my company.  Right now, people access them through the web in their browsers. 

They access them with IE, Chrome, and Firefox.  The documents sometimes get really slow when you make a selection like 5, 10, or more seconds even on my 12G ram system.  That is because a lot of data is loaded into the browser cache as I understand if you have a million or more records. 

Is there any thing I can do to speed up the document?  Is there a way to index the data to speed it up?  Is there away to change the amount of memory the browser uses with QV to speed it up?  Is there something that can be done on the server side?  Is there something that done around decreasing the amount of data in the doument to speed it up? 

[deepakk]

hi,

I am attaching the Qlikview Opimization Document.

There are many ways of optimizing the document like  compressing the data, using multiple box o of list box,

avoid writing if statements in dimensions, removing unwanted fields etc.

Increasing the RAM will surley boost ur performance but I personally feel that this sholud be the last option.

I hope the attach application helps you out. If you can attach doc with sample data and provide  info like

tables and their rows, we might able to discuss further  and provide better solution.

[#3]

Mostly in pivot tables, is there anyway to not have it reload the whole table when I do a drill-down?

[deepakk]

hi Brandon,

It doesn't reload the data it filter  out the data when you select a field. You can optimize your pivot table but removing replacing if statement with set analysis or calulcating fields from script and then using it the pivot table.

Deepak

[#5]

There really aren't any if statements in the pivot tables just losts of records and expressions.  The only if statement I have switches the sign of a negative sum calculation. 

[deepakk]

hi,

The above mention where the best practice we follow.. if you can provide a sample file then we can look into it and help u out on the same