How to get value sum while choose one date?

[#1]

Dear Master Qlik,

I have problem with sum, i have this table :

Date	Value	Stock	Sum
01/03/2014	100000	10	10.000
01/04/2014	150000	15	16.667
01/05/2014	200000	20	22.500

What i want is value in column sum, when i click Date 01/05/2014, then i will get the value of sum.

The process to get the value of Sum = Value in Date (01/01/2014,01/04/2014,01/03/2014) get summed(200.000+150.000+100.000) and then get divide with the value of stock in date 01/05/2014 : ((450.000/20) = 22.500).

Thanks for the help,

[maxgro]

try to add this expression

RangeSum(Above(sum(Value), 0, RowNo())) / sum(Stock)

[#3]

Dear Massimo,

Your answer is really something, thanks very much.

But i have one little problem, if this date cross a year then the sum not working cos it's likely bound to a year.

would you mind to help me again ? Thanks before, i really appreciate your answer.

Kind regard's

[sunny_talwar]

I think if you provide a more comprehensive sample data, we might be able to help you better.

Best,

Sunny

[#5]

Dear Mr. Sunny,

I'am sorry before but i think my problem was solved.

Thanks for your concern.

Regard's

Hadi

[#6]

Dear All,

Thanks for the help, i really appreciate the care and attention from all the master qlik.

Regard's,

Hadi

[sunny_talwar]

Great and Sorry