How to work effectively loading data from Crosstabs?

[rmuhammad]

Hi All

I am new to QV and I am struggling with crosstabs when loading data into Qlikview. Experts please guide me on how to work effectively with these crosstabs.

For example this is how my data looks like

			Oct-14		Nov-14		Dec-14		Jan-15		Feb-15		Mar-15		Apr-15
products	Product Desc	Sold to Cust	Gross $	Qty	Gross $	Qty	Gross $	Qty	Gross $	Qty	Gross $	Qty	Gross $	Qty	Gross $	Qty
gear1	Jacket blue	Walmart	10215	10086	6884	14462	14723	6722	9773	10214	9885	14516	8659	7100	8172	6833
gear2	Jacket Red	Target	12941	9727	13301	7155	13887	13589	6292	14074	14025	6376	10083	7740	9466	9412
gear3	Jacket Black	Bay	14229	11919	9970	6011	10060	8979	12842	14102	8814	6640	14918	8440	6241	7059

How do I script this, I tried Crosstab option but periods and 2 measures making it difficult.

Thanks

Rashid

[Gysbert_Wassenaar]

Maybe you can use this: multi_header_pivot_import.qvw