topic Re: How to change the Master Calendar in QlikView

How to change the Master Calendar

Wed, 30 Apr 2014 05:08:44 GMT

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

Wed, 30 Apr 2014 08:49:39 GMT

Hi all

Please respond any one..

richard_pearce6 — Wed, 30 Apr 2014 09:00:30 GMT

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

Wed, 30 Apr 2014 09:18:44 GMT

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 — Wed, 30 Apr 2014 09:45:20 GMT

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)