topic Re: Calendar Date to Fiscal Calendar Month in QlikView

Calendar Date to Fiscal Calendar Month

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

Hello,

I need to map my field [Purchase Date] to a fiscal period and fiscal year. I already have a common load statement that gives the following fields:

LOAD CalendarDate,

FiscalYear,

FiscalPeriod,

FiscalWeek,

cFYr_Flag,

cFPr_Flag,

cFWk_Flag,

FiscalQuarter,

cFQ_Flag,

FiscalMonth,

FiscalDay,

YearStart,

QuarterStart,

PeriodStart,

YearEnd,

QuarterEnd,

PeriodEnd,

FiscalMonthYear,

FROM

I would like to use the PeriodStart and PeriodEnd fields to make bounds for the [Purchase Date] field in the second load. Is there a way to reference these values between the two load statements? If not, does anyone have a good way to map to fiscal month?

Thanks

Re: Calendar Date to Fiscal Calendar Month

Anil_Babu_Samineni — Fri, 06 Apr 2018 15:07:51 GMT

May be https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/IntervalMatch.htm

Re: Calendar Date to Fiscal Calendar Month

Anonymous — Fri, 06 Apr 2018 15:13:33 GMT

Could you provide a more in depth example?

Re: Calendar Date to Fiscal Calendar Month

Anonymous — Fri, 06 Apr 2018 17:44:29 GMT

I found this example: QlikView Tutorials | QlikView Scirpting | QlikView IntervalMatch Function - YouTube

However, is there a way to dim this as one field?