How can i convert rows to column in pivot table

[Madhura]

This is the sheet that I created in Tableau. How can I replicate it in QlikView? The values are the sum of sales (in the block). I have tried creating a pivot table, but I can't get months as columns; all months are in one column instead of different columns. Thanks in advance.

[Clement15]

Hello, normally you should be able to put dimensions in columns in a pivot table

[LRuCelver]

You are either using the wrong chart, have set up the pivot table incorrectly or there is a problem with your data model.

Here is how it should look:

And here is the data I've used:

Sales:
Load
	"Product Line",
    Date(MakeDate(Year, Month), 'MMMM YYYY') as "Order Month",
    Num(Sales) as Sales
Inline [
Product Line, Year, Month, Sales
Classic Cars, 2003, 1, 36550
Classic Cars, 2003, 2, 18940
Classic Cars, 2003, 3, 97090
Classic Cars, 2003, 4, 57550
Classic Cars, 2003, 5, 92910
Classic Cars, 2003, 6, 43840
Motorcycles, 2003, 1, 
Motorcycles, 2003, 2, 22290
Motorcycles, 2003, 3, 10770
Motorcycles, 2003, 4, 21810
Motorcycles, 2003, 5, 19820
Motorcycles, 2003, 6, 1860
];

[Madhura]

Im not getting any options for rows and columns.

[LRuCelver]

Click on your dimension and drag it to the top right corner of your chart:

Drop it there and it should be used as the columns:

[Madhura]

Got it,thank you so much