1 Reply Latest reply: Oct 11, 2012 5:41 AM by Khim Hoe Tan RSS

    Data Model Question

    Dominic Ayling

      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