Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
sbaldwin
Partner - Creator III
Partner - Creator III

Hi have you tried something like this:

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

thanks

Steve

View solution in original post

1 Reply
sbaldwin
Partner - Creator III
Partner - Creator III

Hi have you tried something like this:

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

thanks

Steve