Discussion board where members can get started with QlikView.
ı checked but no....
no solution .....
nothing in hand.
Would you be able to share a sample?
Just thought I'd check something before I looked at the script?
Do you need to perform it in the script? You can get the result you want in a chart such as a straight table from your original data?
ensure the sort is on term
term as dimension
expression sum(stock value) but tick accumulate total in the bottom LH corner of expressions.
Ok my friends. It worked.
The problem is CASE SENSITIVITY (upper case problem) ı solved it.
Thank you very much for your helps.
Sum(STOK_BEDELI) + RangeSum(Alt(Peek('Accumulated Stock Value'), 0))
as [Accumulated Stock Value]
Group By STOK_DONEM
Order By STOK_DONEM;
that works. thanks.
yes ı tried it but it gives dynamic sum, not static,
when you filter the 'term' it changes the sum,
but we had needed static solutions here.
you've got your answer so thats good
Its academic now but another way is to use the rangesum and above functions. Ive reproduced your requirement using both the accumulate and the rangesum methods
rangesum(above(sum(stockvalue),0,rowno())) (doesnt need the accumulate flag)