Cross table

karensmith — Mon, 29 Jun 2009 08:02:07 GMT

Looking for a way to transpose data from columns to records.

Our Sales and Forecast information is summarized in one file in monthly columns. I would l like to use this summarized file in QV. Is there a way to cross this data to transpose monthly buckets from columns to rows.

Fields: Customer, Part #, Product Group, Year, Qty1, Qty2, Qty3, Qty4, Qty5, Qty6, Qty7, Qty8, Qty9, Qty10, Qty11, Qty12. Then there are another 12 fields fields for Amount Values.

In this case Year = 2008(FY)

Qty1= April 2008 , Qty4= July 2008, ...Qty 11= Feb 2009, Qty12 = March 2009.

Would like new table to display Customer, Part #, Product Group, Year, Month_qty, Month_Amt, Month_YYYY.

Would like to cross did data in QV. Can cross table handle this? If yes, how? How will we handle crossing generic names to MM YYYY values?

Thanks in advance!!

Cross table

stephencredmond — Mon, 29 Jun 2009 22:21:48 GMT

Hi Karen,

When I do this, I will generally load the data twice - once to get in the Qty and once to get the Values. Quite straightforward with a fixed format like this using the cross table wizard.

Stephen

topic Cross table in QlikView

Cross table

Cross table