Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Columns of Straight table

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!

5 Replies
thonipad
Contributor III

Columns of Straight table

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

Not applicable

Columns of Straight table

None.

Not applicable

Columns of Straight table

i think you should see about CrossTable.

im not sure im new in QV ^^.

Not applicable

Columns of Straight table

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

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

Not applicable

Columns of Straight table

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!