8 Replies Latest reply: Feb 8, 2012 12:19 AM by jagan mohan rao appala RSS

    Multiple Series in Line Chart

      Hi,

      I appreciate all I have learned using the QlikView Community.  I hope someone can help - my question may have a simple answer and I am just missing it - I have searched the Community and have not found a solution - we currently use QlikView 9 SR4.

       

      I am trying to create a line graph with 2 (or more) expressions.  The expressions are at week level; however, we want the dimensional axis to display the quarter level.    The sample data is in the table below and I am including a sample graph created in excel - I can't seem to make this work in QlikView:

       

       

      q1
      
      
      
      q2
      
      
      
      q3
      
      
      q4
      
      
      
      
      CW1
      CW2
      CW3
      CW4
      CW5
      CW6
      CW7
      CW8
      CW9
      CW10
      CW11
      CW12
      CW13
      CW14
      CW15
      BOM
      20
      19.8
      19.6
      19.4
      19.2
      19
      18.8
      18.6
      18.4
      18.2
      18
      17.8
      17.6
      17.4
      17.2
      TARGET
      
      
      
      
      25
      25
      25
      25
      
      
      
      22
      22
      22
      22
      
      
      

       

       

      sample chart.jpg

       

      Any ideas?

      Thanks!