Change the table layout

[kushalthakral]

Hi all

I have developed on report where output is like below

Month	A	B	C	D
Jan	10	20	30	40
Feb	20	30	40	20

But according to the business i need to show the above output like below:

	Jan	Feb
A	10	20
B	20	30
C	30	40
D	40	20

So is there any way to convert the output

Thanks

Kushal Thakral

[MK_QSL · Accepted solution]

Go to presentation tab and select Horizontal

Update : This is available only in Straight Table.

For Pivot table, you need to re arrange Dimensions... from Row to Column and Column to Row

[#3]

Hi Kushal,

Use a pivot table and start dragging the column "month" towards right and then top until you see a blue arrow. Once you see that just leave it there and you will receive the desired output.

You might need to expand the other columns by clicking on the "+" sign.

[sudeepkm]

Assume that  A,B,C and D are the values of a dimension field called Product Type and Jan, Feb are values of Time Dimension field Month and the 10, 20 numbers are count of Products or something else then you can use Pivot table in QlikView to achieve the expected result table.

Please see the attached file.

[kushalthakral]

Thank you All

But my requirement is to do this in straight table which was answered correctly by Manish

Regards

Kushal Thakral