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: 
Not applicable

How to make the expression into load script?

Hi,

Can you help me converting an expression into load script? It kinda fibonacci structure.

sum([Amount Loan])-sum( aggr( rangesum( above( sum([Principal Payment]),0,12) ),Month))

TYPE          MONTH          VALUE          RESULT SHOULD BE

A               Jan                  4                         4

A               Feb                 5                          9

A               Mar                 1                         10

------------------------------------------------------------------------------------------------

B               Jan                 6                         6

B               Apr                 1                         7

B               Jun                 3                        10

I'm lookin' forward for your help.

Thanks,

Bill

0 Replies