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

    Aggregating data using preceding load.

    qlik tech

      Hi,

       

      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 .

       

      Eg:

       

      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?

       

      Thanks.