Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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