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 sum of ACCOUNTNUM starting with 2 will be the sum total prior to the month

To find the sum of ACCOUNTNUM starting with 2 will be the sum total prior to the month in transdate as if transdate = 2012-06, Opening of 21624000 shall be equal to -150,000, and if ACCOUNTNUM starting with 4 and 6 to be. totals prior to the month in that year but not more than that years. ex transdate = 2012-12, Opening of 49112000 shall be equal to -96.3 and transdate of 64120100 = 2013-09, Opening of 64120100 shall be equal to 2706027.4.

If you know script let me know or sent .qvw file please.

0 Replies