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: 
giovanneb
Creator II
Creator II

Script to accumulate data for financial statement year, months

Hello community, I have the following situation:

I loaded a table from a financial statement to group by qty of installments paid the payment year and months, it loads correctly however need to load a table with the amount of accumulated payments remembering that there are months that can not occur and even payments occur in other months, following code below:

So I created a solution for using for loop, however I'm dealing with a database of over 1 million records and it is extremely slow to load, I need another solution.

in waiting, thanks

LOAD

  ID_DOC,

  YEAR,

   MONTH,

   count(DATE) AS PAY_MONTH

Resident DOCUMENT

Group by ID_DOC, YEAR, MONTH

order by ID_DOC, YEAR, MONTH;

1 Solution

Accepted Solutions
giovanneb
Creator II
Creator II
Author

1 Reply
giovanneb
Creator II
Creator II
Author

I found the perfect solution, thanks


http://community.qlik.com/message/335470#335470