accumulate in straight table

[syukyo_zhu]

i have a table A in which i have my sales et sales of product A per date.

date	sales	product A
01/01/2015	100	50
02/01/2015	101	51
03/01/2015	102	52
04/01/2015	103	53
05/01/2015	104	54
06/01/2015	105	55
07/01/2015	106	56
08/01/2015	107	57
09/01/2015	108	58
10/01/2015	109	59

I want to calculate the rate cumulate product/sale, so i use "full accumulation" in my expression, it's ok for columns sales et product, but false for column rate cumulate

date	sales	product A	rate cumulate
01/01/2015	100	50	0,5
02/01/2015	201	101	1,002487562
03/01/2015	303	153	1,507438057
04/01/2015	406	206	2,01482722
05/01/2015	510	260	2,524631141
06/01/2015	615	315	3,036826263
07/01/2015	721	371	3,55138937
08/01/2015	828	428	4,068297583
09/01/2015	936	486	4,587528352
10/01/2015	1045	545	5,109059452

. i want to get a result like this one.

date	sales	product A	rate cumulate
01/01/2015	100	50	0,5
02/01/2015	201	101	0,502487562
03/01/2015	303	153	0,504950495
04/01/2015	406	206	0,507389163
05/01/2015	510	260	0,509803922
06/01/2015	615	315	0,512195122
07/01/2015	721	371	0,514563107
08/01/2015	828	428	0,516908213
09/01/2015	936	486	0,519230769
10/01/2015	1045	545	0,5215311

thanks

[sunny_talwar]

How is rate getting calculated here? Is it Product A/sales?

Best,

S

[Anonymous]

Did you try  the following ?

[product A]/[Sales]

[Anonymous]

Here basically you are trying to use the chart labels and not Qlikview Data model fields

[its_anandrjs]

Hi,

In any straight chart try this way

Dim:- date

Expr1:-  sum(sales) // With full accumulation select

Expr2:- sum([product A])  // With full accumulation select

Expr3:- Sum( [product A] )  / Sum( sales ) //No Accumulation

You expecting this output

Regards

Anand

[sunny_talwar · Accepted solution]

Update: Expressions Used

1) RangeSum(Above(Sales, 0, 500))

2) RangeSum(Above([Product A], 0, 500))

3) RangeSum(Above([Product A], 0, 500))/RangeSum(Above(Sales, 0, 500))

All these are without accumulation.

Is this what you are looking for? I have used RangeSum(Above(...)) instead of accumulation.PFA

Best,

S

[syukyo_zhu]

yes

[syukyo_zhu]

it don't work

[syukyo_zhu]

yes but it don't work

[Anonymous]

Can you please share the application if it is ok?