Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

2 Calendars in a single dashboard ? Query

Hi ,

I am currently in the process of updating a tab in an exisiting dashboard. My issue with the process is that the current dashboard uses Standard calendar for all its tabs and the one I am updating requires the Fiscal calendar. How could I use both calendars in a dashboard. ? As this is my first dashboard, I am stuck with the basics. Any help would be useful.

Thanks.

4 Replies
Highlighted

You still only need a single master calendar . The calendar would use date as the key and include calendar month and calendar year as well as fiscal month/period and fiscal year in the same table.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted

Here is a simple script:

Let vFiscalStart = 4;        //first month of fiscal year

Let vMinDate = Num(MonthStart(Today(), -24)); //or other logic if required

Let vMaxDate = Floor(MonthEnd (Today()));

Calendar:

LOAD *,

  If(Month < $(vFiscalStart), Year - 1, Year) As FiscalYear,

  If(Month < $(vFiscalStart), Month + 13 - $(vFiscalStart), Month + 1 - $(vFiscalStart)) As FiscalPeriod

;

LOAD Date(nDate) As Date,

  Year(nDate) As Year,

  Month(nDate) As Month,

  Day(nDate) As Day

  // other date fields as required...

;

LOAD $(vMinDate) + RecNo() - 1 As nDate

AUTOGENERATE $(vMaxDate) - $(vMinDate) + 1;

(Edit: changed RowNo() to RecNo())

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Partner
Partner

Try this from Rob Wunderlich

Search Recipes | Qlikview Cookbook

Regards

Highlighted
Creator
Creator

Thank you Jonathan Dienst and Maximiliano Velez. It so happens that the master calendar has provisions for fiscal year and the std year format, all I had to do was create the values and set it to FIN_month to denote financial month.

I did try using the script given and it made the system slow. I am not sure of the reason behind it.

jonathan dienst