Loop in a Load

[Seier-Alsenz]

Hi guys,

im new in qlik app development and have following question.

i have following data:

ID, Name, BeginDate, EndDate

i want to create for each year which is between BeginDate and EndDate create a data set und count the num of networkdays for each year/dataset.

unfortunately I don't really understand how to include the do-loop in the load command without causing a syntax error.

do you have some examples?

kind regards

[canerkan · Accepted solution]

Hi Seier-Alsenz,

try something like this:

Table:
Load
ID,
Name,
BeginDate,
BeginDate + IterNo()-1 as Date,
EndDate
From ....
while BeginDate + IterNo()-1 <= EndDate;

This should do the trick. All you have to do from there is to mark the working days.

Let me know if it helped.

Regards,

Can

[Seier-Alsenz]

Thank you for your help. Thats exactly the function i need.

Unfortunately, this seems to be indicative of my 3-day development qlik-sense training, that this simple functionality was not presented there.

[canerkan]

Hi Seier-Alsenz,

I'm glad I could help you! Please mark correct answers as solutions so other people having the same problem can see that there might be a solution for them as well.

Regards,

Can