How to change the Master Calendar

[#1]

Hi All

I Have a QVW which will run  on every SUnday to generate weekly snapshop of data.

each week data is appended to previous week.. kine that it will run..

Now i want all the weekly snap shot of data for all weeks. and by the month end i have to see all the weekly data with monthwise.

How can we do that..PLease check the attachment

[#2]

Hi all

Please respond any one..

[richard_pearce6]

Hi Abhinav,

It's difficult to understand your requirements,

Are you wishing to extract a further time at month end and flag it as such?

Do you wish to report in your dashboard the last weekly figure in the month as monthend?

Do you wish to aggregate your weekly data into a monthly figure?

Or, is it something else you wish to achieve?

Thanks

Richard

[#4]

Hi

the qvw which i gave works like..it runs on every sunday at 6pm.

if i run today (30-4-2014) it will take the timesmtmap of last week sunday and generates data.

now what i want  is

if i run the qvw at 30-4-2014 at 12pm it has to take the timestamp as 30-4-2014 12:00:00 and run.

after the last weekend of this month(27-4-2014) it has to stop and

for remaing three days it has to run on month end(30-4-2014).

please modify the master calendar according to that.

[richard_pearce6]

You could use the date function MonthEnd() and WeekStart()

The SET command works out the where clause. The condition is checking if today is the last day of the month.

SET vWhereClause = "=If (    floor( MonthEnd( Today(0))) = Floor(Today(0))

     , '[Data Timestamp] >= WeekStart (Today(0))  and [Data Timestamp] <=Now()'  

     , '{Your Weekly Where Clause}'

     ) ";

Load *

From [FileName.Qvd] (QVD)

where $(vWhereClause)