Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Highlighted
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

Tags (2)
1 Reply
Not applicable

Re: Data Model Question

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.