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.

giovanneb
Not applicable

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;

Tags (3)
1 Solution

Accepted Solutions
giovanneb
Not applicable

Re: Script to accumulate data for financial statement year, months

I found the perfect solution, thanks


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

1 Reply
giovanneb
Not applicable

Re: Script to accumulate data for financial statement year, months

I found the perfect solution, thanks


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