Master Calendar Script

MK9885 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I've seen many users here asking the questions about how to get previous month, week, year, quarter data.

This can be done directly into the Master calendar to avoid any confusion when writing a set expression and getting it wrong.

We can simply create flags for each field and use it in our front end as ....Flag={1}........

I'm attaching the Master Calendar script I've created to do same and it might be helpful for others to just use sum({<LastMonthFlag={1}}>}Sales) rather than using

sum({<Month={$(=Month(AddMonths(Max(Date),-1)))}>}Sales) to get previous month's sale.

It also has Last quarter flags, Last month last per quarter flag, last year flag, current quarter, current month, weekend dates etc....

I edited this script as I wanted to skip those long syntax used in Set Analysis to get previous month/year.

All you need to do is copy the script as it is from the attached document and run it. And DateID will be your key matching to your Fact Dates, hence you need to convert the dates in your fact to same format as DateID from Master to link it.

You're welcome to add anything extra to it/find an error in the attached script.

Thanks.

Re: Master Calendar Script

PrashantSangle — Thu, 13 Dec 2018 08:58:33 GMT

Hi,

It is really helpful to everyone. Just one suggestion instead of posting your document as question in this group, you can post it in QilkView Docuement path. So that If any one want to refer it he / she will search in document tab.

Regards,

Prashant Sangle

topic Master Calendar Script in QlikView

Master Calendar Script

Re: Master Calendar Script