Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would know if it is possible to implement this kind of expression in qlikview chart
Expression(t)=sum(qt)+expression(t-1)
so Expression is a function of the instant before. The table loaded is like
t | qt |
---|---|
1/1/2009 | 100 |
2/1/2009 | 100 |
3/1/2009 | 100 |
3/1/2009 | 200 |
6/4/2010 | 400 |
1/1/2019 | -100 |
2/1/2019 | -100 |
3/1/2019 | -100 |
3/1/2019 | -200 |
... | ... |
So I expect to see
Expression(1/1/2009)=100
Expression(2/1/2009)=100+100
Expression(3/1/2009)=100+100+100
Thanks in adavance
Hi have you tried something like this:
=rangesum(above(qt,0,rowno()))
thanks
Steve
Hi have you tried something like this:
=rangesum(above(qt,0,rowno()))
thanks
Steve