1 Reply Latest reply: Jan 7, 2012 6:58 AM by Ingo Hardieck RSS

    Aggregation at different level

      I have 2 tables

       

      Table1:

      Sales Order      Item

      123                  ABC

      123                  DEF

      456                  XYZ

      456                  PQR

       

      Table2:

      Sales Order     Step Type    Code

      123                 113              ZZZ

      456                 113              YYY

       

       

      Now in my report output I want following:

       

      Sales Order    Item    Code

      123                ABC    ZZZ

      123                DEF    ZZZ

      456                XYZ     YYY

      456                PQR    YYY

       

      How do I do this? In short Table2 has data at Sales Order level and in my report I want to aggregate Code at Sales Order level.

        • Aggregation at different level

          Hi there,

          if your data model is as simple as above then Qlikview will link your 2 tables through the common key (Sales Order) the way you want.

           

          You can test this by:

           

          1) Create a new Qlikview Document and paste this code into the Script Editor

           

          Table1:

          LOAD * INLINE [

              Sales Order, Item

              123, ABC

              123, DEF

              456, XYZ

              456, PQR

          ];

           

           

          Table2:

          LOAD * INLINE [

              Sales Order, Step Type, Code

              123, 113, ZZZ

              456, DEF, ZZZ

          ];

           

          2) Reload the Document

           

          3) Open the Table Viewer

          - check how your data is linked

           

          4) Add Sheet Object "Table Box"

          - select the 3 fields Sales Order, Item, Code