Newbie Question - How do I create a line braph with dates on X axis

[#1]

Hi,

Thanks for taking the time to read this post.  Just started working with Qlik and I'm trying to build my first KPI.  I have a chart generated from data from an internal website, and this is what is in it :

DATE	DP1
12/26/2011  8:00	182.08
12/26/2011  20:00	140.03
12/27/2011  8:00	168.02
12/27/2011  20:00	148.43
12/28/2011  8:00	171.17
12/28/2011  20:00	0.61
12/29/2011  8:00	174.08
12/29/2011  20:00	155.66
12/30/2011  8:00	164.19
12/30/2011  20:00	162.05
12/31/2011  8:00	171.17

So.... here is what I need to do.. I'd like to have a chart with DATE on the x-axis and DP1 data on the Y axis.  It seems so simple.. right.. , but I'm having some major issues. 

Here is how I get the data into QV :

SET TimestampFormat='MMM-DD @ h';

FermKPI:

     LOAD     

          Timestamp(Date) as Date,

          [DP1],

     FROM

     [http://xxxxxxx/exportresults.php?exp_id=1151]    

     (html, codepage is 1252, embedded labels, table is @3);

What I did manage to get is a graph with X axis the way I want it to be : mmm-dd @ h, but the data points are not connected.  Under Dimensions I have Date first and DP1 second.  Now when I graph it, I can not get the valuse to be connected by a line, they are just individual points on the graph.  Any ide how to fix this?  Am I even doing this chart correctly to get my dates listed??

Thanks for all your help..

[#2 · Accepted solution]

Since you are creating a chart I believe Date needs to be setup as a dimension and DP1 as an expression.  You could also just create just a table box.

[#3]

Yup... that was exactly it, I kept on playing with it after I left the question and just got it working around teh same time you responded..  Thanks a bunch..

Another question though came up..   can I put a text box on the graph now??  I don't like it how the legend shrinks my graph over and I want to place the legend on-top of the chart.. any ideas ??

-Hubert

[#4]

Yes, just enter your text and make the background transparent. You will also want to go into the Layout tab and make sure the Layer is set to Top or the chart will overlap it.