I would suggest you to increment the data into a QVD file and use the entire file torun your dashboard.
lets say your data becomes previous every week. So on Week 1 load the current data. Once week 2 comes add, week 2 data to the existing Qvd file by using a concatenate statement and so on. Make sure you have a unique posting date column, using which you will be able to track back which weeks posting it was.
There are number of uses if you store the data in a QVD as , its compression ratio is far better than any other format. Qlik can handle large volumes of data so the data volume might not be a problem as well.
hope this helps
- Sangram Reddy.