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||...|
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 ?