topic Re: Newbie Question - How do I create a line braph with dates on X axis in QlikView

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

Wed, 04 Jan 2012 17:34:41 GMT

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

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

Wed, 04 Jan 2012 18:56:24 GMT

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.

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

Wed, 04 Jan 2012 18:58:56 GMT

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

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

Wed, 04 Jan 2012 19:12:11 GMT

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.