Aggregation at different level

[#1]

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.

[#2 · Accepted solution]

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