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

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