topic Generate a line Chart in QlikView

Generate a line Chart

Tue, 18 May 2010 19:28:45 GMT

Hello Together,

unfortunately, I could find nothing in the forum and need some help.

Given:

The field [date] has, for example, 4 records. To every [date] there is n [values].
To every [date] there is in the field n [values].

For example:
5/5/2010-> 10; 10 ; 13 sum= 33
5/6/2010-> 8; 9 sum= 17
5/7/2010-> 12 sum= 12
5/8/2010-> 5; 8; 10 sum= 23

the goal:

I want a line chart. The X-axis should indicate the available [date], e.g., 5/5/2010, 5/6/2010 5/7/2010 ...

For the date 5/5/2010 the sum 33 = 33 should be associated. y = 33
For the date 5/6/2010 the sum 33 + 17 = 50 should be associated. y = 50
For the date 5/7/2010 the sum 33+17+12 = 62 should be associated. y = 62
For the date 5/8/2010 the sum 33+17+12+ 23 = 85 should be associated. y = 85

How I do make this? How must the formula look in the chart? Thank you very much !

Generate a line Chart

hector — Tue, 18 May 2010 19:37:24 GMT

Hi, did you try "Full Accumulation" in the "Expression" tab?, this could work fine for what you want.

rgds

Generate a line Chart

Tue, 18 May 2010 19:42:26 GMT

Hi Hector M. ,

did not work ! Another idea ? maybe in the formula ?

Generate a line Chart

Tue, 18 May 2010 19:43:16 GMT

Accumulation

In this group, you decide if and to what extent you wish your graph to display accumulated values. One of three settings is selected. No Accumulation disables accumulation of y-values. With Full Accumulation selected, all y-values are successively accumulated. The Accumulate ... Steps Back allows you to decide how many previous values you want to include in the accumulation.

Chart Properties: Expressions page you can see the above accumulation option and I am thinkking this option might help you.

Generate a line Chart

hector — Tue, 18 May 2010 19:55:22 GMT

so, a line chart with dimension "Date" and expression "Sum(Field)" + Full Accumulation

or upload an example

rgds

Generate a line Chart

Tue, 18 May 2010 19:56:20 GMT

Here is the example, I hope that helps.

Generate a line Chart

Tue, 18 May 2010 19:58:25 GMT

Here is the place were you set it.

Generate a line Chart

Tue, 18 May 2010 20:10:48 GMT

Hello together and many thanks to you to help me.

I believe I had wrong expressed myself.

Here my formula.

=Sum ([values]) * 5.8 / ((Max (num ([datum])) - num ([6/6/2010])) * 50000 / 34)

This formula calculates to me a factor. It works well.

Explanation of the fields:

[values]-> can have many values

Max (num ([datum]))-> This are my data fields. Here only the most actual data recordset is selected.

If you can start with that ?

Generate a line Chart

Tue, 18 May 2010 20:18:46 GMT

Please provide some data and example like every one attaches small qvws so that it is more clear to understand.

Generate a line Chart

Tue, 18 May 2010 20:27:18 GMT

i make a qvw file for you. How can i upload it here ?

Generate a line Chart

Tue, 18 May 2010 20:34:31 GMT

Please read this

http://community.qlik.com/forums/t/15787.aspx

Generate a line Chart

Tue, 18 May 2010 20:44:45 GMT

In the line chart the date fields [Datum] should stand in X axes.
In the Y axis the respective values eTKP

Here the value pairs (X, Y):

(03.05.2010 ; 7,018623737213 )
(04.05.2010 ; 6,806580684582 )
(05.05.2010 ; 6,735899667585 )
(06.05.2010 ; 6,700559159188 )
(07.05.2010 ; 6,679354854183 )

I owe you one !

Generate a line Chart

Tue, 18 May 2010 20:47:01 GMT

thank you

Generate a line Chart

Tue, 18 May 2010 21:19:43 GMT

On the Expression tab of chart, click on check box full accumaltion and values on data points and i think you should get what you are expecting. If not please post the expected result as you mention in first post.

Thank you

Generate a line Chart

Tue, 18 May 2010 21:23:32 GMT

Hi devang,

sorry, but the full accumulate dont show me the expected values.

I want a graph with the posted values.

Look at the eTKP value for each date.

Please help.

Generate a line Chart

Wed, 19 May 2010 12:27:30 GMT

Hi There,

can somebody help me ?

Thank You

Generate a line Chart

Wed, 19 May 2010 14:01:53 GMT

Try switching on Full Acumulation for the expression in the line chart, this should answer it for you and is the easiest way to do it.

Generate a line Chart

Wed, 19 May 2010 21:09:56 GMT

Hello,

unfortunately, this does not help me. The result with full accumulation, accumulates all y values.

And thats not what i am searching for. I have made some screenshots. I hope. it is now unequivocal what I want to do.

Many greetings,
honour

Generate a line Chart

Wed, 19 May 2010 21:11:42 GMT

Generate a line Chart

Wed, 19 May 2010 21:12:33 GMT