topic Re: Looping the CALL function for each day of 2013 in QlikView

Looping the CALL function for each day of 2013

qlikviewforum — Fri, 07 Mar 2014 07:58:42 GMT

I want to use the below CALL function to call the sub-routine which creates the daily QVD. I want to loop the below call function in such a way that it calls the sub-routine for all the dates of 2013 instead of harding the date value in the CALL function for each date.

CALL DailyQvd ('SOURCE_DATA','YYYYMMDD');

Can someone help me out for this?

Re: Looping the CALL function for each day of 2013

Peter_Cammaert — Fri, 07 Mar 2014 08:43:19 GMT

LET vNum = DayNumberOfYear(YearEnd('1/1/2013'));

FOR i = 1 TO $(vNum)

LET vDate = date(YearStart('1/1/2013') + $(i) - 1);

CALL DailyQvd('$(vDate)', 'YYYYMMDD');

If your second parameter specifies the input date format, change the second LET statement to:

LET vDate = date(YearStart('1/1/2013') + $(i) - 1, 'YYYYMMDD');

Re: Looping the CALL function for each day of 2013

qlikviewforum — Fri, 07 Mar 2014 09:21:12 GMT

Thank you for your effort.

I couldn't see 'SOURCE_DATA' in your script which is my first parameter. Please let me know if it is not clear!

Re: Looping the CALL function for each day of 2013

Peter_Cammaert — Fri, 07 Mar 2014 09:28:44 GMT

'SOURCE_DATA' is a string constant. I replaced it with a date value for each successive day in 2013.

If the example code doesn't fit your requirements, please explain what parameter values this SUB expects.

Re: Looping the CALL function for each day of 2013

qlikviewforum — Fri, 07 Mar 2014 09:51:38 GMT

Ok, SUB expects below parameter! Please let me know if you have anymore questions.

SUB DailyQvd ('Sales','20130805');

Re: Looping the CALL function for each day of 2013

Peter_Cammaert — Fri, 07 Mar 2014 09:56:47 GMT

I see. This will do better then:

LET vNum = DayNumberOfYear(YearEnd('1/1/2013'));

FOR i = 1 TO $(vNum)

LET vDate = date(YearStart('1/1/2013') + $(i) - 1, 'YYYYMMDD');

CALL DailyQvd('SOURCE_DATA', '$(vDate)');

Re: Looping the CALL function for each day of 2013

qlikviewforum — Fri, 07 Mar 2014 11:01:24 GMT

Thank You!

I will check and update you shortly....