topic Straight Table showing possible values and excluded values in QlikView

Straight Table showing possible values and excluded values

Tue, 04 Aug 2015 03:47:20 GMT

Hi,

I have an order record which I would like to use it to create a table to know the relationship between orders. Let's say, in PO 1, customer ordered item A, together with item B and item C, PO 2, customer order item B, item C, PO3, customer order, item A and item C. I would like to know which items are order together. Thus, I would like to create a straight table which format like

Item S # / Item order together with item S which is top 1 / Qty / Item order together with item S which is top 2 / Qty

A B XX C XXX

Is it possible to do so? Appreciate for your help!

Re: Straight Table showing possible values and excluded values

senpradip007 — Tue, 04 Aug 2015 04:29:35 GMT

Can you share a sample qvw with sample data and expected output ?

Re: Straight Table showing possible values and excluded values

Tue, 04 Aug 2015 05:21:11 GMT

Ｔｈｅ　ｓｏｕｒｃｅ　ｄａｔａ　ｌｉｋｅ　ｔｈｉｓ：

PO#	Item#	Qty
1	A	200
1	B	300
2	A	200
2	C	300
3	A	100
3	B	200
3	C	300

Ｉ　ｗｏｕｌｄ　ｌｉｋｅ　ｔｏ　ｈａｖｅ　ｔｈｅ　ｏｕｔｐｕｔ　ｌｉｋｅ　ｔｈｉｓ：

Item	Top 1 item wihich order together	# of order attached together	Qty	Top 2 item wihich order together	# of order attached together	Qty
A	C	2	600	B	1	300
B	A	2	300	C	1	300
C	A	2	300	B	1	200