Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Kind of expression in qlikview chart

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

tqt
1/1/2009100
2/1/2009100
3/1/2009100
3/1/2009200
6/4/2010400
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

Tags (2)
1 Solution

Accepted Solutions
sbaldwin
Contributor III

Kind of expression in qlikview chart

Hi have you tried something like this:

=rangesum(above(qt,0,rowno()))

thanks

Steve

1 Reply
sbaldwin
Contributor III

Kind of expression in qlikview chart

Hi have you tried something like this:

=rangesum(above(qt,0,rowno()))

thanks

Steve

Community Browser