In my report I have a requirement to show transactions both at an aggregated level and at an individual transaction level, I have several million transactions (though selections have to be made before viewing this level). Currently I import all data at transaction level only and Qlikview aggregates the values up where necessary.
My question is would I see a performance improvement if I created a table with values pre-aggregated and link that to a transactions table, take all aggregated values from the aggregated table and only use transaction level values when showing transaction level?
If the transaction level data is stored in a separate QVW, then the performance of the summarize QVW should improve. So you'll have 2 QVW, one for summary and one for transaction. You can use "document chaining" to link these two QVW together.