Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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:

SerialProduct Group AProduct Group AAQuantity 2012.01Qty 2012.02Qty 2012.03Sales 2012.01Sales 2012.02Sales 2012.03...
xxxBBO100200150100200150
xxyBBP150125160150125160


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

1 Reply
vijay_iitkgp
Valued Contributor

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

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

Community Browser