How to display Metrics in Row level and Dimension in Column Level in the Pivot table

[#1]

Dear QlikView Genius,

I have one table(Extracted from the DB server) like shown below in my QVW file.

Region	Gross Item	GMV	Net Item	NMV
FR	11510	€ 3,207,233	8,933	€ 4,223,423
FR	214452345	€ 2,768,158	128,267	€ 54
USA	43435	€ 1,299,909	9,890	€ 5,445
USA	2329	€ 734,162	1,547	€ 464,359
CA	12011	€ 628,217	9,809	€ 455
CA	4313	€ 570,159	3,551	€ 445,714
AUS	11563	€ 244,022	9,518	€ 5,445
AUS	8673	€ 208,151	7,374	€ 176,209
NZ	2070	€ 37,190	1,576	€ 4,554
NZ	410	€ 4,325,554	344	€ 55,454

My aim of the report in the Pivot table format like shown below:

	AUS	CA	FR	NZ	USA
Gross Item	20236	16324	214463855	2480	45764
GMV	452173.761	1198375.767	5975391.467	4362744.437	2034070
Net Item	16891.4802	13359.21471	137200.5276	1919.947031	11437.17
NMV	181654.446	446168.5386	4223477	60008	469803.6

Note: My main QV source table has many attributes like date,Item,seller and so on information. I want use Item category and date as filter.

I would be really grateful if you answer me how could fix this issue.

Thanks & Regards,

Bob

Message was edited by: Robert Bosco JOHN PETER

[#2]

HI,

If you are using a pivot table you should be able to drag and drop dimensions and expressions as you want.

Have your already tried that?

Greetings,

Angel

EDIT: In Properties of the table -> Presentation -> "allow Pivoting" should be checked.

[#3]

I am not sure..but i think we can do it by cross table loading..

[#4]

Hi,

Thanks for your prompt reply. could you please let me know how to do that since i am very new in the QV?

Regards,

Robert

[#5]

Hi robert, can you post here your qlikview document example?

[#6]

Hi,

Attached the sample QVW file.

Regards,

Robert

[tresesco · Accepted solution]

May be like attached qvw?

Just pull the expression row down to left, it will form the first column(as if dimension); pull the Region dimension up to right top to get the columns.

[#8]

Cool Thank you so much..Interesting