topic Re: Line chart in QlikView

Line chart

Fri, 25 May 2012 15:11:06 GMT

Hi all.
I have this line chart:
[http://localhostr.com/file/lf6Pm33M5QYV/Immagine.gif | http://localhostr.com/file/lf6Pm33M5QYV/Immagine.gif]
Is it possible to visualize in the chart values that rappresent the variation of price between each point?

Line chart

Jason_Michaelides — Fri, 25 May 2012 16:26:09 GMT

Sure - add another expression:

Sum(Price)-Above(Sum(Price))

Hope this helps,

Jason

Re: Line chart

Mon, 28 May 2012 07:06:39 GMT

Doesn't work. I need that the variation is rapresented like this example http://localhostr.com/file/X917v8MSBKE7/Immagine.gif but I use a line chart.

Re: Line chart

Jason_Michaelides — Mon, 28 May 2012 08:38:02 GMT

How's this?

Re: Line chart

Mon, 28 May 2012 09:27:33 GMT

aYes but I have a line chart with dimension "date" and expression "price" and I want to add the variation of price between each date. E.g. 0,040 between 05/04/2012 and 21/04/2012; 0,004 between 02/04/2012 and 05/04/2012 and so on.

Re: Line chart

Jason_Michaelides — Mon, 28 May 2012 09:30:12 GMT

Please post a sample of your app.

Re: Line chart

Tue, 29 May 2012 07:14:09 GMT

I have a situation like this demo app. Now I want to add in the line chart an expression that represents the variation of actual value between each data. E.g. it must indicate between the years 2006 and 2007 the difference of the actual values 12,622,185 and 14,906,127 and so on.

Re: Line chart

Jason_Michaelides — Tue, 29 May 2012 08:46:43 GMT

So I think my original solution is still the correct one...Actual-Above(Actual)

See attached. In the top chart both the values and the variations use the same scale, in the bottom chart there are different scales on left and right.

Hope this helps,

Jason

Line chart

Tue, 29 May 2012 10:23:57 GMT

Thanks