Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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