topic scheduler Problem in QlikView

scheduler Problem

svsudhakar — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have created one PDF report, I need to schedule that report as weekly , last week and quarterly reports .

currently manually I am selecting the calendar in the dashboard and sharing the reports .now I need to schedule that reports .

please suggest is there any way to select the last week dynamically in scheduler.

Thanks in Advance,

Re: scheduler Problem

tresB — Mon, 22 Dec 2014 05:21:58 GMT

Last week: =Week(Today())-1

Re: scheduler Problem

svsudhakar — Mon, 22 Dec 2014 05:45:10 GMT

Is it possible to write this expression in scheduler level

Re: scheduler Problem

tresB — Mon, 22 Dec 2014 06:18:07 GMT

You want to select last week from a field in the application, right? If so, create an inline field with two values like :

Let vCurrWeek=Week(Today());
Let vLastWeek=$(vCurrWeek)-1;
Load * Inline [
Week, WeekSel
$(vCurrWeek), $(vCurrWeek)
$(vLastWeek), $(vLastWeek)
];

Now use this WeekSel field for selection in the publisher/server.

Re: scheduler Problem

svsudhakar — Mon, 22 Dec 2014 09:18:06 GMT

Hi tresesco,

Thanks for your reply. With inline table I am able to select the last week but its not giving the current year. Its giving irrespective of all years.

I have created the same flag in script level as below its working fine.

if( Year(Today())=year(Date),if( Week(Today())-1 =Week(Date),1,0)) as [Last Week],

Re: scheduler Problem

Mon, 22 Dec 2014 10:14:31 GMT

Hi Sudhakar,

you might want to look at the Inweek() function, makes for a simpler code.

Inweek(Date, today(), -1)*-1 AS [Last Week]

-1 in the function offsets to the prior week, *-1 to then turn the trues to positive

hope that helps

Joe