Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Is there any reason why Pivot table is not an option?
None.
i think you should see about CrossTable.
im not sure im new in QV ^^.
http://community.qlik.com/forums/t/41924.aspx
if your problem is just like mine CrossTable will help you solve this.
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!