Excel data - Charts - Data normalization - Time values in column

[#1]

Hello,

I'm looking for a way to display a huge series of products in line charts.

The format I'm getting data in looks like this:

Serial	Product Group A	Product Group AA	Quantity 2012.01	Qty 2012.02	Qty 2012.03	Sales 2012.01	Sales 2012.02	Sales 2012.03	...
xxx	B	BO	100	200	150	100	200	150
xxy	B	BP	150	125	160	150	125	160

I would like to display the data in 2 line charts, 1 for quantities and 1 for sales, with time on the X axis and summarized by product group A or AA.

Up to know, I was flattening the data in Access using a time field.

Is there a way in Qlikview to use directly the raw data ?

Thanks,

Robert

[vijay_iitkgp]

Hi Robert,

You can use cross table for this. First load Dimension and Quantity data and do the cross table  and then again load dimension and Sales data and do the cross table and after that using concatenation or link table you can get your desired result.

Hope this will help.

Vijay