1 Reply Latest reply: Jan 24, 2012 3:53 AM by Vijay Kumar RSS

    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