6 Replies Latest reply: Sep 28, 2017 11:47 AM by qlik tech RSS

    Aggregating data using preceding load.

    qlik tech



      Using my first set of QVDs I want to tranform some data and load this at an aggregated level.


      My first set of QVDs is at a very low granularity, I have few flags derived at that granularity but would need the data only for flag =1 .




      QVD at detailed level

      Month   Account Num  Flag Amount

        1             xx                      1            10

        1             yy                      0             20


      Summary QVD (where flag =1 )

      Month            Amount

      1                         10


      Can I do a preceding load where I have only the data for flag = 1?