Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

fisland92
New Contributor III

Re: accumulate with load

ı checked but no....

no solution .....

nothing in hand.

Re: accumulate with load

Would you be able to share a sample?

john_s_w_wood
Contributor

Re: accumulate with load

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.

fisland92
New Contributor III

Re: accumulate with load

Ok my friends. It worked.

The problem is CASE SENSITIVITY (upper case problem) ı solved it.

Thank you very much for your helps.

new:

Join(stok)

LOAD STOK_DONEM,

  Sum(STOK_BEDELI) + RangeSum(Alt(Peek('Accumulated Stock Value'), 0))

  as [Accumulated Stock Value]

Resident stok

Group By STOK_DONEM

Order By STOK_DONEM;

that works. thanks.

fisland92
New Contributor III

Re: accumulate with load

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.

thanks anyway.

john_s_w_wood
Contributor

Re: accumulate with load

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)

accum1.JPGaccum2.JPG

Kind Regards