Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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.