Column to Row in qlikview

[#1]

Hi , I got a requirement that i have shuffle column as row.  below is the requirement

Stock	item	Itemtype	Sale	InStock
Store1	I1	Product1	1	1
Store1	I2	Product2	0	1
Store2	I1	Product1	0	0
Store2	I3	Product2	3	4

AS

Item	Item Type	Stock	Store1	Store2
I1	Product1	Sale	1	0
	Product2	InStock	1	0
I2	Product1	Sale	0	3
	Product2	InStock	1	4

I will look forward to appreciate your answer

[adamdavi3s]

Can you not simply deploy as a pivot table in the front end?

[#3]

Please try this

tab1:

CrossTable(salesinstack, value, 3)

  LOAD Stock,

    Item,

    itemtype,

    Sale,

    instock

FROM

(ooxml, embedded labels, table is Sheet1);

Tab2:

generic Load Item,

Stock,value Resident tab1;

[beck_bakytbek]

or you can use crosstable

beck

[#5 · Accepted solution]

Yes Adam, I have already done with the requirement but forgot to close the thread. Thank you

[#6]

pivot table :dimentions are item,itemtype,salesinstack,store1,store2

                 Expression:Sum(item)

Item	itemtype	salesinstack	store1	store2	Sum(Item)
11	product1	instock	1	0	22
		Sale	1	0	22
12	product2	instock	0	-	12
			1	-	12
		Sale	0	-	12
			1	-	12
13	product2	instock	-	3	13
				4	13
		Sale	-	3	13
				4	13

itemtype	store1	store2	Item	salesinstack
product1	1	0	11	instock
product1	1	0	11	Sale
product2	0		12	instock
product2	0		12	Sale
product2	1		12	instock
product2	1		12	Sale
product2		3	13	instock
product2		3	13	Sale
product2		4	13	instock
product2		4	13	Sale

Please try this

under transformation wizard select crosstable ,set qualifier field is 3,Attribute field is salesinstack and Data field is Value.

tab1:

CrossTable(salesinstack, value, 3)

  LOAD Stock,

    Item,

    itemtype,

    Sale,

    instock

FROM

(ooxml, embedded labels, table is Sheet1);

Tab2:

generic Load Item,

Stock,value Resident tab1;