topic Re: Data Model Question in QlikView https://community.qlik.com/t5/QlikView/Data-Model-Question/m-p/402883#M1333371 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 11 Oct 2012 09:41:48 GMT 2012-10-11T09:41:48Z Data Model Question https://community.qlik.com/t5/QlikView/Data-Model-Question/m-p/402882#M1333368 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>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).&nbsp; Currently I import all data at transaction level only and Qlikview aggregates the values up where necessary.</P><P></P><P>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?</P><P></P><P>Appreciate any advice?</P><P></P><P>Thanks</P><P></P><P>Dominic</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Data-Model-Question/m-p/402882#M1333368 2026-01-26T18:19:17Z Re: Data Model Question https://community.qlik.com/t5/QlikView/Data-Model-Question/m-p/402883#M1333371 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 11 Oct 2012 09:41:48 GMT https://community.qlik.com/t5/QlikView/Data-Model-Question/m-p/402883#M1333371 2012-10-11T09:41:48Z