Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Model Question

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

1 Reply
Not applicable
Author

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.