topic DATA FROM ROW NEEDED IN COLUMN in QlikView

DATA FROM ROW NEEDED IN COLUMN

Wed, 27 Jul 2011 09:29:19 GMT

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

DATA FROM ROW NEEDED IN COLUMN

Wed, 27 Jul 2011 12:48:27 GMT

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..

DATA FROM ROW NEEDED IN COLUMN

rahulgupta — Wed, 27 Jul 2011 14:41:08 GMT

Hey Hi,

Cross Table Functionality will solve out your issue.

Kindly check, else let me know.

Regards

Re: DATA FROM ROW NEEDED IN COLUMN

deepakk — Wed, 27 Jul 2011 15:23:45 GMT

hi,

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

Deepak

DATA FROM ROW NEEDED IN COLUMN

Wed, 27 Jul 2011 15:38:09 GMT

Thanks.. it's working!!!