Discussion board where members can get started with QlikView.
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?
Is there any reason why Pivot table is not an option?
i think you should see about CrossTable.
im not sure im new in QV ^^.
if your problem is just like mine CrossTable will help you solve this.
You can use a pivot table, you just have to drag the header of the column to de top right corner of the table