topic Re: Loop in a Load in App Development

Loop in a Load

Seier-Alsenz — Wed, 02 Mar 2022 12:45:07 GMT

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

Re: Loop in a Load

canerkan — Wed, 02 Mar 2022 12:53:30 GMT

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

Re: Loop in a Load

Seier-Alsenz — Thu, 03 Mar 2022 07:43:48 GMT

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.

Re: Loop in a Load

canerkan — Thu, 03 Mar 2022 12:25:56 GMT

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