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

Tue, 24 Jan 2012 08:38:22 GMT

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

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

vijay_iitkgp — Tue, 24 Jan 2012 08:53:33 GMT

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

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

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

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