Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
simon20
Partner
Partner

Files disappear in while loop

Hi,

I have an app where I am trying to create a future cash flow. The data set is several files where each row has a start and an end date. I then create a monthly calendar from start date to end date for each contract like below:

[Main data]:

LOAD

*,

FROM [lib:\\Qlik\*.xlsx];

// Some join tables to get all dates and information in the same table.

a = varMinDate

do while a <= varMaxDate

LOAD

....

RESIDENT [Main Data]

AddMonths(a,1)

loop

My issue is that during the loop, all information from the files after the first seems to be lost after the loop. I thought all data was stored in the resident table, but it seems that the loop stops after it reach the last row in the first file.

Any idea on how to solve this?

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

I think it has nothing to do with loading data from a resident table else with your variablen-assignment and the loop-logic. Therefore I suggest to check the variables and number of loop-iterations with TRACE statements which will be displayed within the progress-window and the log-file.

- Marcus