Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
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?
Appreciate any advice?
Thanks
Dominic
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.