DATA FROM ROW NEEDED IN COLUMN

[#1]

Dear All,

I have below weekly data for daily sale on different product.

Product ID	18/07/2011	19/07/2011	20/07/2011	21/07/2011	22/07/2011	23/07/2011	TOTAL QTY SOLD	TOTAL QTY REORDERED	TOTAL QTY NEED TO ORDER
ABC	1	1	0	1	0	1	4	4	0
DEF	0	0	0	2	1	2	5	3	2
GHI	1	0	0	1	1	0	3	3	0
JKL	0	1	1	3	0	0	5	4	1
MNO	1	2	3	0	0	10	16	10	6
PQR	0	2	3	5	0	0	10	10	0
STU	5	1	1	1	1	5	14	4	10
VWX	1	2	3	3	0	0	9	9	0
XYZ	4	1	1	1	0	0	7	7	0
QTY SOLD ON DATE	13	10	12	17	3	18	73	54	19

I need below table as a summary. Please help.

Weekly Report	QTY
TOTAL QTY SOLD	73
TOTAL QTY REORDERED	54
TOTAL QTY NEED TO ORDER	19

[#2]

hi,

create pivot table with your dimentions and expression go-> properties-> presentation->see at the left bottom select Horizontal.in qlik view v9.It may help u..

[rahulgupta]

Hey Hi,

Cross Table Functionality will solve out your issue.

Kindly check, else let me know.

Regards    

[deepakk · Accepted solution]

hi,

Please find   a sample application in the attachment. I hope this sorts out your issue.

Deepak

[#5]

Thanks.. it's working!!!