1 Reply Latest reply: May 6, 2011 4:53 PM by Steve Dark RSS

    Time Line Chart questions

      Hi All,

      I have a quick question: how to create a time line chart in Qlikview.

       

      I have 2 column : Phone and Released date

      iphone , 2/2/2010

      droid , 2/10/2010

      etc, 11/2/2011

       

      I need to show the time line with the date on the X axis and the phone name  shown on the chart  and not shown as legend.

       

      It similar to the time line project.

       

       

       

       

      Regards,

      Senjaya

        • Re: Time Line Chart questions
          Steve Dark

          Hi there,

           

          What I would suggest is that you add a counter to each row of that dataset - you will also need to ensure your dates are formatted correctly.  This inline statement should give an idea:

           

          TimeLine:

          LOAD

                    1 as PhoneCount,

                    Phone,

                    date(date#(Date, 'DD MMM YYYY'), 'DD MMM YYYY') as Date

          INLINE [

          Phone,Date

          iPhone,1 Jan 2011

          Android,24 Mar 2011

          ];

           

          With the data in this format you can create a combo chart.  Set the Date as the dimension for the chart.  Set the first Expression to be sum(PhoneCount) and select that to be a symbol.  Put a second Expression in simply of Phone - set this to be Values On Data Points.  You will also want to check that you have a Continuous axis.

           

          This should give you something to start with, I would sugest you want to also want to play about with the formatting.  The attached .qvw file should give some ideas.

           

          Hope that helps.

          Regards,
          Steve