Columns of Straight table

[#1]

Hi,

I am a loading a table from sql. The query is like this:

Select Year, Product, Bookings from BookingTable

There are 5 distinct products:

ProductA ProductB, etc.

From this table I want to make a table that has Year, and the distinct Product Names as the columns.

So it would look like:

Year, ProductA, ProductB, ProductC...

2011 $1 $2 $3

Anyone know if this is possible?

Thanks!

[Anonymous]

Is there any reason why Pivot table is not an option?

[#3]

None.

[#4]

i think you should see about CrossTable.

im not sure im new in QV ^^.

[#5]

http://community.qlik.com/forums/t/41924.aspx

if your problem is just like mine CrossTable will help you solve this.

[#6]

Hi,

You can use a pivot table, you just have to drag the header of the column to de top right corner of the table

Regards!