Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Progressive values

Hi,

I've the following table:

YEAR     MONTH     ORDER     ARTICLE     SUPPLIER     PURCH_VALUE    

2012          3               A1          ART1          ABC               1900 

2012          6               A1          ART1          ABC                 650

2012          8               A1          ART1          ABC                580

2012          9               A1          ART1          ABC               1000           

What I'm trying to do is to calculate the PAID_VALUE in this way:

YEAR     MONTH     ORDER     ARTICLE     SUPPLIER     PURCH_VALUE     PAID_VALUE  TOTAL PAID

2012          3               A1          ART1          ABC               1900                      0                     1900

2012          6               A1          ART1          ABC                 650                    1900                  2550 

2012          8               A1          ART1          ABC                580                     2550                  3130 

2012          9               A1          ART1          ABC               1000                    3130                   4130

The last column represent the total paid value: choosing  June , the total paid should be 1900, in August 2550 as sum of the previous

payments and so on.

How can I create the PAID_VALUE column ? I'm getting crazy

Thanks

1 Reply
SunilChauhan
Champion
Champion

use below for TOTAL PAID

if(rowno()=1,sum(PURCH_VALUE) ,PURCH_VALUE+above(PURCH_VALUE))

hope this helps

Sunil Chauhan