Hi Vishal,
Performance may depends on various aspects
Data :
Reduce the data as much as possible, comment/drop unused fields in the Dashboard, so that the size of the file is reduced.
Reduce the number of rows, suppose if you dashboard is having 20 years of data, check with users whether they really going to use all the data for analysis, if not limit to last 5 years data.
If you are not using time part in Dashboard for analysis remove the time from date fields.
If you are having floating point numbers and if you are ignoring that then convert to integer, this will reduce the size.
Expressions:
Don't display all the records in the Straight/Pivot/Table box objects, restrict user to select some filters.
Use Set analysis in the expressions.
Don't use calculated dimensions.
Bring flags for calculation wherever possible.
Do all possible calculations in the scripting part, so that the charts loads faster.
Don't display all the charts in a single sheet, split it into multiple sheets or show/hide using buttons.
Hardware:
Since you are using 3GB Qlikview file, your system hardware should also be upto the mark, RAM and processors should be more for this. If you are having very less configuration upgrade it. Qlikview performs better if you have better hardware especially RAM.
Hope this helps you.
Regards,
Jagan.
.png "Luminary Alumni"){kind=icon}
