Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Master Qlik,
I have problem with sum, i have this table :
Date | Value | Stock | Sum | |
---|---|---|---|---|
| 100000 | 10 | 10.000 | |
| 150000 | 15 | 16.667 | |
| 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,
try to add this expression
RangeSum(Above(sum(Value), 0, RowNo())) / sum(Stock)
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
I think if you provide a more comprehensive sample data, we might be able to help you better.
Best,
Sunny
Dear Mr. Sunny,
I'am sorry before but i think my problem was solved.
Thanks for your concern.
Regard's
Hadi
Dear All,
Thanks for the help, i really appreciate the care and attention from all the master qlik.
Regard's,
Hadi
Great and Sorry