How to create two different calendar from drop down selection.

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

Hi,

In my application I have two different fiscal year which is based on division.

For company 'A' Fiscal year is from (Jan to Dec) and for company 'B' Fiscal year is from (Oct to Sept) and date field is same for both the division.

Now Client requirement is to create two different calendar for company A and B so that from drop down say 'Calendar' they can select company'A' or either 'B'.based on that selection Fiscal year option should come.

Please suggest.

Re: How to create two different calendar from drop down selection.

ajsjoshua — Wed, 04 May 2016 05:23:25 GMT

Hi,

Script:

----------

SET vFiscalYearStartMonth = 4;

LET vStartDate = Num(YearStart(Today(), -1));

LET vEndDate = Num(YearEnd(Today()));

FiscalCalendar:

LOAD

Dual('Q' & Ceil(FiscalMonth/3), Ceil(FiscalMonth/3)) AS FiscalQuarter, // Fiscal Calendar Quarter

Dual(Text(Date(MonthEnd(Date), 'MMM')), FiscalMonth) AS FiscalMonthName; // Fiscal Calendar Month Name

LOAD

Year(Date) AS Year, // Standard Calendar Year

Month(Date) AS Month, // Standard Calendar Month

Date(MonthEnd(Date), 'MMM') AS MonthName, // Standard Calendar Month Name

Dual('Q' & Ceil(Month(Date)/3), Ceil(Month(Date)/3)) AS Quarter, // Standard Calendar Quarter

Mod(Month(Date) - $(vFiscalYearStartMonth), 12)+1 AS FiscalMonth, // Fiscal Calendar Month

YearName(Date, 0, $(vFiscalYearStartMonth)) AS FiscalYear; // Fiscal Calendar Year

LOAD

Date($(vStartDate) + RangeSum(Peek('RowNum'), 1) - 1) AS Date,

RangeSum(Peek('RowNum'), 1) AS RowNum

AutoGenerate vEndDate - vStartDate + 1;

topic How to create two different calendar from drop down selection. in QlikView

How to create two different calendar from drop down selection.

Re: How to create two different calendar from drop down selection.